第1个回答 推荐于2019-08-04
private void GetDataByParmSqlCommand()
{
SqlConnection sqlc = new SqlConnection(DBUtility.SqlHelper.ConnectionStringLocalTransaction); //取连接字符串饼建立sqlconnection
try
{
sqlc.Open();
SqlCommand com = new SqlCommand("select * from c6 where usr_id = usr_id", sqlc);
SqlParameter parm = new SqlParameter();
parm.ParameterName = "@usr_id";
parm.Value = "01;
com.Parameters.Add(parm);
com.ExecuteNonQuery();
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(com);
sda.Fill(ds, "c6");
DataTable dt = ds.Tables[0];
textbox.Text ="用户代码:"+ dt.Rows[0]["usr_id"].ToString().Trim() +"用户名称:"+ dt.Rows[0]["usr_name"].ToString().Trim() ;
//这样组合一下就可以了,看你要显示哪些信息
}
catch (Exception ee)
{
MessageBox.Show(ee.Message, "");
}
finally
{
sqlc.Close();
}
}本回答被网友采纳