第1个回答 2020-02-22
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";
}