Question

怎样使用C#对数据库的每一行进行读取？

Answer 1

SqlConnection
sql
=
new
SqlConnection("连接字符串");
SqlCommand
command
=
new
SqlCommand("查询语句",
sql);
SqlDataReader
reader=
command.ExecuteReader();
while
(reader.Read())//循环读每行
{
//取列
string
l1=
reader["列名1"].ToString();
string
l2
=
reader["列名2"].ToString();
this.richTextBox1.Text
+=
l1+","+l2+"\n";
}
access数据库也差不多，换成OleDbConnection
,OleDbCommand,OleDbDataReader类就行：
OleDbConnection
sql=new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=数据库名;User
Id=admin;Password=;");
OleDbCommand
command
=
new
OleDbCommand("查询语句",
sql);
OleDbDataReader
reader
=
command.ExecuteReader();
while
(reader.Read())//循环读每行
{
//取列
string
l1
=
reader["列名1"].ToString();
string
l2
=
reader["列名2"].ToString();
this.richTextBox1.Text
+=
l1
+
","
+
l2
+
"\n";
}

Answer 2

连接字符串：String
connectionString
=
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=product.mdb";
建立连接：OleDbConnection
connection
=
new
OleDbConnection(connectionString);
如果需要读取数据的话，对象名都一样，只是稍稍变了下，你看下建立连接应该就能明白，和操作SQL差不多，但是只能用SQL语句，不能使用存储过程哦