using System.Data.SqlClient;
....
string strSelect = "select Name,Tel from Guest";
string source = "User ID=sa;Password=;Initial Catalog=Guest;Data Source=你的数据库服务器名;";
SqlConnection conn = new SqlConnection(source);
conn.Open();//connect database
SqlCommand cmd = new SqlCommand(strSelect,conn);
SqlDataReader dr = cmd.ExecuteReader();
while( dr.Read() )
{
text1.Text = dr["Name"].ToString();
text2.Text = dr["Tel"].ToString();
}
dr.Close();//close DataReader
conn.Close();//close connection
....
string strSelect = "select Name,Tel from Guest";
string source = "User ID=sa;Password=;Initial Catalog=Guest;Data Source=你的数据库服务器名;";
SqlConnection conn = new SqlConnection(source);
conn.Open();//connect database
SqlCommand cmd = new SqlCommand(strSelect,conn);
SqlDataReader dr = cmd.ExecuteReader();
while( dr.Read() )
{
text1.Text = dr["Name"].ToString();
text2.Text = dr["Tel"].ToString();
}
dr.Close();//close DataReader
conn.Close();//close connection
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货