如何在执行一条语句后,怎样才能得到执行返回的结果呢?在线等待...... OleDbCommand.ExcuteScaler();返回的是sql语句的记录的第一行第一列的值,类型为Object 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用oledbdatareader:public void ReadMyData(string myConnString) { string mySelectQuery = "SELECT OrderID, CustomerID FROM Orders"; OleDbConnection myConnection = new OleDbConnection(myConnString); OleDbCommand myCommand = new OleDbCommand(mySelectQuery,myConnection); myConnection.Open(); OleDbDataReader 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();} 关于c# winform 异步调用数据,显示 C# 跟踪线程问题 net用什么加密源码软件??? C# winform 程序如何自动刷新 c# c/s的连接池实现 treeView 树的问题(cs) 爬虫:html中script标签的解析 C# winform ColorDialog 怎样实现每次进入后焦点在上次选择的颜色 vs2010以ADO方式访问Excel2010出现问题 十万火急~~!!在C#中怎么做一个只有密码和用户名登录的程序!!求各位高手顶立相住 Console中如何实现类似Linux的tail功能? 百思不得其解,很奇怪的问题。
string mySelectQuery = "SELECT OrderID, CustomerID FROM Orders";
OleDbConnection myConnection = new OleDbConnection(myConnString);
OleDbCommand myCommand = new OleDbCommand(mySelectQuery,myConnection);
myConnection.Open();
OleDbDataReader 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();
}