Question

C#如果我想列出数据库内的表Table的所有数据，那么接下来该怎么写？

App.config

类。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data;
using System.Data.Sql;
namespace ConsoleApplication1
{
class Program
{
class A
{
public A()
{
string sqlstr = ConfigurationManager.ConnectionStrings["SqlServer"].ConnectionString;
}
}
static void Main(string[] args)
{
}
}
}

Answer 1

qlConnection conn=new SqlConnection(sqlstr );
conn.Open();
SqlCommand sqlcmd=new SqlCommand();
sqlcmd.CommandText ="select * from student";
sqlcmd.Connection=conn;
SqlDataAdapter adp=new SqlDataAdapter(sqlcmd);
DataTable dt=new DataTable();
adp.Fill(dt);