using PreSqlData.DataProcess;

usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;

usingSystem.Data.SqlClient;


namespaceAllSaveGrid
{
publicpartialclassForm1:Form
{

DataSetds=newDataSet();

publicForm1()
{
InitializeComponent();
GridControl_Bind();
}
publicvoidGridControl_Bind()
{
SqlClasssc=newSqlClass();
//DataSetds=newDataSet();
ds=sc.SelTable();//获取DataGridView的数据源
dataGridView1.DataSource=ds.Tables[0];
}

privatevoidbutton1_Click(objectsender,EventArgse)
{

SqlConnectioncon=newSqlConnection("server='localhost';database='Work';user='sa';password='123'");
SqlCommandcmd=newSqlCommand();
cmd=con.CreateCommand();
cmd.CommandText="select*fromTable_gongzi";
SqlDataAdapterda=newSqlDataAdapter(cmd);

SqlCommandBuildercb=newSqlCommandBuilder(da);//使用SqlCommandBuilder的话，首先要求你的表有主键
//然后他会根据你提供的查询语句，生成插入，修改，删除语句
//再根据DataTable对应的数据行状态来调用对应的语句执行数据库操作
da.Update(ds.Tables[0]);
dataGridView1.Update();
}

privatevoidbutton2_Click(objectsender,EventArgse)
{
DataRowViewdrv=dataGridView1.SelectedRows[0].DataBoundItemasDataRowView;
drv.Delete();

SqlConnectioncon=newSqlConnection("server='localhost';database='Work';user='sa';password='123'");
SqlCommandcmd=newSqlCommand("select*fromTable_gongzi",con);
//SqlCommandcmd=newSqlCommand();
//cmd=con.CreateCommand();
//cmd.CommandText="select*fromTable_gongzi";

SqlDataAdapterda=newSqlDataAdapter(cmd);
SqlCommandBuildercb=newSqlCommandBuilder(da);//必须newSqlCommandBuilder否则da.Update报错
da.Update(ds.Tables[0]);
dataGridView1.Update();
}
}
}

转载声明： 本文转自http://blog.csdn.net/shanzhaikaifa/archive/2009/08/13/4443931.aspx