哦!爸 的小日記

【SqlDataAdapter 】

using (SqlConnection dataConnection = new SqlConnection())
{

   Connection conn = new Connection();
   dataConnection.ConnectionString = conn.DB15_PTERP;

   dataConnection.Open();
   SqlDataAdapter adp = new SqlDataAdapter();

   string sql = "select ACPT_VOU_NO,ACPT_VOU_TYPE  from AC_ACPT_M  WHERE ACPT_VOU_NO = @NO";

   adp.SelectCommand = new SqlCommand(sql, dataConnection);

   adp.SelectCommand.Parameters.Add("@NO", textBox1.Text);

   DataSet dt = new DataSet();

   adp.Fill(dt, "AC_ACPT_M");

   BindingSource bd = new BindingSource(dt, "AC_ACPT_M");

   dgvData.DataSource = bd;

   label3.Text = "此次查詢筆數為: " + bd.Count.ToString();

   dataConnection.Close();

   adp.Dispose();

}

【SqlDataReader】

Connection conn = new Connection();

if (textBox1.Text.Length != 0)
{
  sql = "select ACPT_VOU_NO,ACPT_VOU_TYPE from AC_ACPT_M WHERE ACPT_VOU_NO=@NO";
}
else
{
   sql = "select ACPT_VOU_NO,ACPT_VOU_TYPE from AC_ACPT_M ";
}
  //SqlDataReader
using (SqlConnection dataConn = new SqlConnection( conn.DB63_PTERP))
{
  dataConn.Open();

  using(SqlCommand cmd = new SqlCommand (sql,dataConn))
  {

    if (textBox1.Text.Length != 0)

    cmd.Parameters.Add("@NO",textBox1.Text);

    using(SqlDataReader dr = cmd.ExecuteReader())
    {
      DataTable dt = new DataTable();
      dt.Load(dr);
      dgvData.DataSource = dt;
      dataConn.Close();
      dr.Close();

    }
  }

}