C#中怎么读取SQL数据库表中的数据后显示在一个TEXTBOX中？

Question

如题所述

Answer 1

private void GetDataByParmSqlCommand()\x0d\x0a {\x0d\x0a SqlConnection sqlc = new SqlConnection(DBUtility.SqlHelper.ConnectionStringLocalTransaction); //取连接字符串饼建立sqlconnection\x0d\x0a try\x0d\x0a {\x0d\x0a \x0d\x0a sqlc.Open();\x0d\x0a SqlCommand com = new SqlCommand("select * from c6 where usr_id = usr_id", sqlc);\x0d\x0a SqlParameter parm = new SqlParameter();\x0d\x0a parm.ParameterName = "@usr_id";\x0d\x0a parm.Value = "01;\x0d\x0a com.Parameters.Add(parm);\x0d\x0a com.ExecuteNonQuery();\x0d\x0a DataSet ds = new DataSet();\x0d\x0a SqlDataAdapter sda = new SqlDataAdapter(com);\x0d\x0a sda.Fill(ds, "c6");\x0d\x0a DataTable dt = ds.Tables[0];\x0d\x0atextbox.Text ="用户代码："+ dt.Rows[0]["usr_id"].ToString().Trim() +"用户名称："+ dt.Rows[0]["usr_name"].ToString().Trim() ;\x0d\x0a//这样组合一下就可以了,看你要显示哪些信息\x0d\x0a\x0d\x0a}\x0d\x0a catch (Exception ee)\x0d\x0a {\x0d\x0a MessageBox.Show(ee.Message, "");\x0d\x0a }\x0d\x0a finally\x0d\x0a {\x0d\x0a sqlc.Close();\x0d\x0a }\x0d\x0a }