Question

c#datagridview怎么显示SQL SERVER数据库中的表.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
DataSet aa = new DataSet();
SqlDataAdapter bb;
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection cc = new SqlConnection("Data Source=XP-201201161804\\SQLEXPRESS;Initial Catalog=WB;Integrated Security=True");
//cc.Open();
string sql = "select * from userInfo";
bb = new SqlDataAdapter(sql, cc);
bb.Fill(aa);
dataGridView1.DataSource = aa.Tables["userInfo&quo

Answer 1

using System.Data.SqlClient;
using System.Data;

SqlConnection Conn = new SqlConnection(@"server=DQ\SQLEXPRESS;database=persons;uid=sa;pwd='12345'");

string sql = "select * from [grade]";
SqlDataAdapter da = new SqlDataAdapter(sql, Conn);
DataSet ds = new DataSet();
da.Fill(ds, "grde");
dataGridView1.DataSource = ds;
dataGridView1.DataSource = ds.Tables["grde"];

Conn.Close();
ds.Dispose();
da.Dispose();

追问

我晕加了个表名在后面就好了 ，谢谢啦。