读取表数据的小问题

[casper_moonzhang]

现有一数据表，结构为：
f_no f_beginx f_endx

现想从表的第一行开始遍历整个表，依次取出每行的f_beginx和f_endx，并把他们的值分别赋予变量dbeginx和dendx

刚解除c#，请帮忙。

[bestshl]

OleDbConnection nwindConn = new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;" +
"Integrated Security=SSPI;Initial Catalog=northwind");

OleDbCommand selectCMD = new OleDbCommand("SELECT CustomerID, CompanyName FROM Customers", nwindConn);
selectCMD.CommandTimeout = 30;

OleDbDataAdapter custDA = new OleDbDataAdapter();
custDA.SelectCommand = selectCMD;

DataSet custDS = new DataSet();
custDA.Fill(custDS, "Customers");
参考一下这个

[LoveCleverDog]

在学习的过程中要看几个类

SqlConnection SqlCommand SqlDataReader SqlDataAdapter等类

private static void CreateCommand(string queryString,
string connectionString)
{
using (SqlConnection connection = new SqlConnection(
connectionString))
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandTimeout = 15;
command.CommandType = CommandType.Text;
command.CommandText = queryString;

connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",
reader[0], reader[1]));
}
}
}

希望对楼主有帮助。