【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();
}
}
}
留言列表