string cmdstring = "SELECT ID,Address,TelNumber FROM Test WHERE TelNumber = 424";
SqlConnection con = new SqlConnection("data source = localhost; database = mydb; uid = sa; pwd =");
SqlCommand selcommand = new SqlCommand(cmdstring,con);
con.Open();
SqlDataReader myreader = selcommand.ExecuteReader();
if(myreader.Read())
{
string id1 = Convert.ToString(myreader.GetString(0));
TextBox1.Text = id1;
string address1 = myreader.GetString(1);
TextBox2.Text = address1;
string tel1 = Convert.ToString(myreader.GetString(2));
TextBox3.Text = tel1;
}
myreader.Close();
con.Close();
SqlConnection con = new SqlConnection("data source = localhost; database = mydb; uid = sa; pwd =");
SqlCommand selcommand = new SqlCommand(cmdstring,con);
con.Open();
SqlDataReader myreader = selcommand.ExecuteReader();
if(myreader.Read())
{
string id1 = Convert.ToString(myreader.GetString(0));
TextBox1.Text = id1;
string address1 = myreader.GetString(1);
TextBox2.Text = address1;
string tel1 = Convert.ToString(myreader.GetString(2));
TextBox3.Text = tel1;
}
myreader.Close();
con.Close();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货