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;
using System.Data.SqlClient;
using System.Text;
//using Mysql.Data.MysqlClient;
namespace test
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
//连接数据库
SqlConnection sqlcon = new SqlConnection("Data Source=.;Initial Catalog=test;Integrated Security=True;");
try
{
sqlcon.Open();
//获取数据
SqlDataAdapter da = new SqlDataAdapter("select id as 编号,name as 姓名 from name", sqlcon);
//绑定数据
DataSet ds=new DataSet();
da.Fill(ds,"table");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "table";
}
catch (Exception ex)
{
}
finally
{
sqlcon.Close();
}
}
}
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;
using System.Data.SqlClient;
using System.Text;
//using Mysql.Data.MysqlClient;
namespace test
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
//连接数据库
SqlConnection sqlcon = new SqlConnection("Data Source=.;Initial Catalog=test;Integrated Security=True;");
try
{
sqlcon.Open();
//获取数据
SqlDataAdapter da = new SqlDataAdapter("select id as 编号,name as 姓名 from name", sqlcon);
//绑定数据
DataSet ds=new DataSet();
da.Fill(ds,"table");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "table";
}
catch (Exception ex)
{
}
finally
{
sqlcon.Close();
}
}
}
}