Question

c#怎么把几个数据分别显示在几个label上

conn.Open();

string sql = "SELECT "+uid+","+role+","+vip+","+jifen+","+jin+","+touxiang+" FROM xx";

//创建SqlCommand
SqlCommand cmd = new SqlCommand(sql, conn);
就像这句怎么把这些数据分别显示label1-6上
语句没报错但不知道写错没有，如果写错请帮忙纠正

Answer 1

SELECT 的结果可以用SqlDataReader对象读取
你查询时没有采用where条件，查到的结果可能不止一条，处理的时候需要注意
SqlDataReader reader = cmd.ExecuteReader();

//检查是否有记录

if(reader.HasRows)
{
// 开始读记录了

while(reader.Read())
{
//处理记录的数据
Label1.Caption=reader.GetString(0);
Label2.Caption=reader.GetString(1);
......

}

}

追问

string sql = "SELECT "+uid+","+role+","+vip+","+jifen+","+jin+","+touxiang+" FROM xx where="+uid+"";这样改对吗？？？while后面跟着的意思是当读到数据后，然后按uid+","+role+","+vip+","+jifen+","+jin+","+touxiang这个顺序分别排列下去吗

追答

是的，按照Select后面的字段名排列的
select uid,role from xx where uid =''