请教各位
如:
string strconn = "server=.;database=sell;integrated security=true;connect Timeout=30";
SqlConnection conn = new SqlConnection(strconn);
string strQuery = "select ProID from ProStock"; 怎么去获取select查询后所返回的 ProID 值呀?我初学C#请您详细的讲解一下 SqlDataAdapter da = new SqlDataAdapter(strQuery,conn);
如:
string strconn = "server=.;database=sell;integrated security=true;connect Timeout=30";
SqlConnection conn = new SqlConnection(strconn);
string strQuery = "select ProID from ProStock"; 怎么去获取select查询后所返回的 ProID 值呀?我初学C#请您详细的讲解一下 SqlDataAdapter da = new SqlDataAdapter(strQuery,conn);
SqlConnection conn = new SqlConnection(strconn);
string strQuery = "select ProID from ProStock";SqlDataAdapter da = new SqlDataAdapter(strQuery,conn);
DataSet ds= new DataSet();
da.Fill(ds);
SqlCommand dcom = new SqlCommand();
SqlDataReader dread=new SqlDataReader();
string strQuery = "select ProID from ProStock";
string strconn = "server=.;database=sell;integrated security=true;connect Timeout=30";
dcon.ConnectionString = strconn;
dcon.Open();
dcom.CommandText = strQuery;
dread = dcom.ExecuteReader();
dcon.Close();
dread.Read();
int AAA = dread.GetInt32(0); // 这个 AAA 变量里放的就是ProID ,可以用循环读取多行
dread.Close();
Da.fill(dataset);然后从dataset中获取