Question

在c#控制台程序中查询数据库中表，然后显示该表

Answer 1

string connString = @"Data Source=7JRR7E7DLJ2KIXM\SQLEXPRESS;attachDBFilename=|datadirectory|\Database1.mdf;integrated security=true;
user instance=true";
using (SqlConnection connection = new SqlConnection(connString))
{
string sql = string.Format("select * from admin");
using (SqlCommand objCommand = new SqlCommand(sql, connection))
{
connection.Open();
using (SqlDataReader objReader = objCommand.ExecuteReader())
{
if (objReader.HasRows)
{
for (int i = 0; i < 10; i++)
{
string s1="",s2="";
if (objReader.Read())
{
s1=objReader.GetString(0);
s2=objReader.GetString(1);
}Console.WriteLine("{0}{1}",s1,s2);
}
}
}
}
}
Console.ReadKey();

Answer 2

你要怎么显示，一般都用DataGridView显示数据。

Answer 3

无图无法解释