新手问题!
xxd88 2008-07-07 09:35:18 该代码只显示查询出的一条记录!但如果数据库中有多条符合查询条件的记录该如何显示?怎样加循环?
public void bind()
{
string tel = Session["tel"].ToString();
//读取数据库连接字符串
string setting = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
//创建数据库连接
SqlConnection myconn = new SqlConnection(setting);
//打开数据库连接
myconn.Open();
string sql = "select * from Bs where BsrTel='" + tel + "'";
//创建数据库命令
SqlCommand mycmd = new SqlCommand(sql, myconn);
SqlDataReader dr = mycmd.ExecuteReader();
if (dr.Read())
{
string name = dr["BsrName"].ToString();
string slid = dr["SlBh"].ToString();
if (name == "")
{
lbl_name.Text = "抱歉无此人登记过办事!";
}
else
{
lbl_name.Text = dr["BsrName"].ToString();
}
if (slid == "")
{
lbl_slid.Text = "抱歉无您要查找的受理ID!";
}
else
{
lbl_slid.Text = dr["SlBh"].ToString();
}
}
}