创建DataTable


DataSet ds = new DataSet("mydb");

DataTable table = new DataTable("mytable");
table.CaseSensitive = false;
table.MinimumCapacity = 100;
table.TableName = "emp";

DataColumn colEmpno = new DataColumn();
colEmpno.ColumnName = "empno";
colEmpno.DataType = typeof(int);
colEmpno.AutoIncrement = true; //设置自增长
colEmpno.AutoIncrementSeed = 1000;
colEmpno.AutoIncrementStep = 1;
table.Columns.Add(colEmpno);
table.Columns.Add(new DataColumn("empname", typeof(string)));
table.Columns.Add(new DataColumn("hiredate", typeof(System.DateTime)));

DataRow row1 = table.NewRow(); //增加数据
//row1["empno"] = 1000;
row1["empname"] = "apq";
row1["hiredate"] = DateTime.Parse("2009-1-9");
table.Rows.Add(row1);

DataRow row2 = table.NewRow(); //增加数据
//row2["empno"] = 1001;
row2["empname"] = "bob";
row2["hiredate"] = DateTime.Parse("2008-5-1");
table.Rows.Add(row2);

ds.Tables.Add(table);

dataGridView1.DataSource = table;



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;
using System.Configuration;


namespace SqlDataAdapterTest
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
conn.Open();

string sql = "select * from emp";
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
//adapter.Fill(ds);
//dataGridView1.DataSource = ds.Tables[0]; //显示数据
adapter.Fill(ds, "emp"); //给表起个名字
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "emp";

conn.Dispose();
conn.Close();
}

private void button2_Click(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
conn.Open();

string sql = "select * from emp";
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
DataTable table = new DataTable("emp");
adapter.Fill(table);
dataGridView1.DataSource = table.DefaultView; //和dataGridView控件绑定数据

conn.Dispose();
conn.Close();
}

//用DataTable加载SqlDataReader指向的对象
private void button3_Click(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
string sql = "select * from emp";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DataTable table = new DataTable("emp");
table.Load(reader);
dataGridView1.DataSource = table;
reader.Close();
}
}
}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值