SqlCommand cmd = new SqlCommand("select name from nametable where ID='1234'", conn);
conn.Open();
string customName = (string)cmd.ExecuteScalar();
conn.Open();
string customName = (string)cmd.ExecuteScalar();
可以用command:
catCMD.CommandText = ="select name from nametable where ID='1234'";
SqlDataReader myReader = catCMD.ExecuteReader();
myReader.GetString(1):1就是你所要字段的位置,第一个字段是0,以此类推。