高考问答葫芦娃爷爷大全:SqlDataReader怎么用来显示数据!!--asp.net
来源：百度文库 编辑：高考问答 时间：2024/04/29 06:55:18
我是ASP。NET新手，我不知道该怎么显示数据库里的东西，哪位高手帮一下 ？？
你直接引用了vs.net M$的原话啊~~~
你直接引用了vs.net M$的原话啊~~~
[C#]
public void ReadMyData(string myConnString) {
string mySelectQuery = "SELECT OrderID, CustomerID FROM Orders";
SqlConnection myConnection = new SqlConnection(myConnString);
SqlCommand myCommand = new SqlCommand(mySelectQuery,myConnection);
myConnection.Open();
SqlDataReader myReader;
myReader = myCommand.ExecuteReader();
// Always call Read before accessing data.
while (myReader.Read()) {
Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1));
}
// always call Close when done reading.
myReader.Close();
// Close the connection when done with it.
myConnection.Close();
}