怎样读取数据库中的数据？

[feifei576]

SqlCommand cmd=new SqlCommand(sqlCmdText);
cmd.CommandText=sqlCmdText;
cmd.Connection=this.sqlCon;
reader=cmd.ExecuteReader();
是这样吗？

[xxyping]

不是， 你首先必须要连DATABASE啊，
sqlconnection conn=....
sqlcommand cmd=..
sqldatareader
这样

[tianshimeng724]

SqlConnection sqlconn = new SqlConnection("数据库连接字符串");
sqlconn.Open();
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlconn);
DataSet myds = new DataSet();
myda.Fill(myds);
sqlconn.Close();

[mathieuxiao]

SqlConnection conn = new SqlConnection("server=(local);database=myDB;integrated security=true;";
string cmdText= "select * from sometable";
SqlCommand cmd = new SqlCommand(cmdText, conn);

conn.Open();

SqlDataReader reader = cmd.ExecuteReader();

while(reader.Read())
{
   object value = reader.GetValue(0);//可以根据类型取出数据
   //......
}