dim con as new sqlconnection("连接字符串")
dim cmd as new sqlcommand("select name from student where id=你要找的那个人的id",con)
dim reader as sqldatareader
con.open()reader=cmd.ExecuteReader()
label1.text=reader("name").tostring()
con.close()
dim cmd as new sqlcommand("select name from student where id=你要找的那个人的id",con)
dim reader as sqldatareader
con.open()reader=cmd.ExecuteReader()
label1.text=reader("name").tostring()
con.close()
myconn.Open();
string str="select*from news";
SqlCommand mycom=new SqlCommand(str,myconn);
SqlDataReader myreader=mycom.ExecuteReader();
while(myreader.Read())
{
Label1.Text=myreader["new_title"].ToString();
}
myreader.Close();
myconn.Close();
用dataset 方法,然后html页面上绑定,也可以
{
label.text=reader.getstring(0);}