通过长期学习ADO.NET，所以和我们共享一下关于ADO.NET SQLDataAdapter完结对数据库的删去修正和刺进的事例剖析，看完本文你必定能够全面了解ADO.NET的强壮之处，我们从速来看看吧！

#T#本试验方针是要求编写一个应用程序，使用ADO.NET SQLDataAdapter目标完成能够增加、修正、删去学生基本信息的功用。数据库为school，共有六个表，该应用程序中只使用了表student。数据表student中能够先寄存一部分数据，便于后边处理。数据库环境是SQL Server 2005。用鼠标双击各个Button控件，进入.cs文件修正状况预备进行开发。代码ADO.NET SQLDataAdapter动态程序部分如下：

usingSystem; 
usingSystem.Collections.Generic; 
usingSystem.ComponentModel; 
usingSystem.Data; 
usingSystem.Data.SqlClient; 
usingSystem.Drawing; 
usingSystem.Text; 
usingSystem.Windows.Forms; 
 
namespaceWindowsApplication1 
{ 
publicpartialclassForm9:Form 
{ 
privateSqlConnectionmycon; 
privateSqlDataAdaptermyada; 
privateSqlCommandmycomd; 
privateSqlCommandBuildermycbd; 
privateDataSetmyset; 
publicForm9() 
{ 
InitializeComponent(); 
mycon=newSqlConnection("DataSource=LKJ\\SQLEXPRESS;InitialCatalog=school;IntegratedSecurity=True"); 
mycomd=newSqlCommand("select*fromstudent",mycon); 
myada=newSqlDataAdapter(); 
myada.SelectCommand=mycomd; 
mycbd=newSqlCommandBuilder(myada); 
myset=newDataSet(); 
myada.TableMappings.Add("student","student"); 
myada.TableMappings[0].ColumnMappings.Add("SNO","学号"); 
myada.TableMappings[0].ColumnMappings.Add("SNAME","名字"); 
myada.TableMappings[0].ColumnMappings.Add("SEX","性别"); 
myada.TableMappings[0].ColumnMappings.Add("BIRTHDAY","生日"); 
myada.TableMappings[0].ColumnMappings.Add("CLASS","班级"); 
} 
///<summary>
///数据修正 
///</summary>
privatevoidbutton1_Click(objectsender,EventArgse) 
{ 
try 
{ 
//将更改的数据更新到数据表里 
myada.Update(myset.Tables["student"].GetChanges()); 
MessageBox.Show("数据库修正成功","成功信息"); 
//DataTable承受更改,以便为下一次更改作预备 
myset.Tables["student"].AcceptChanges(); 
} 
catch(SqlExceptionex) 
{ 
MessageBox.Show(ex.ToString()); 
} 
} 
///<summary>
///初始化数据 
///</summary>
privatevoidForm9_Load(objectsender,EventArgse) 
{ 
try 
{ 
myada.Fill(myset,"student"); 
} 
catch(SqlExceptionex) 
{ 
MessageBox.Show(ex.ToString()); 
} 
finally 
{ 
mycon.Close(); 
} 
dataGridView1.DataSource=myset.Tables["student"].DefaultView; 
} 
///<summary>
///数据删去 
///</summary>
privatevoidbutton2_Click(objectsender,EventArgse) 
{ 
if(MessageBox.Show("确定要删去当时行数据？","",MessageBoxButtons.OKCancel)==DialogResult.OK) 
{ 
try 
{ 
//从DataTable中删去当时选中的行 
myset.Tables[0].Rows[dataGridView1.CurrentRow.Index].Delete(); 
//将更改的数据更新到数据表里 
myada.Update(myset.Tables[0].GetChanges()); 
MessageBox.Show("数据删去成功！"); 
//DataTable承受更改,以便为下一次更改作预备 
myset.Tables[0].AcceptChanges(); 
} 
catch(SqlExceptionex) 
{ 
MessageBox.Show(ex.ToString()); 
} 
} 
else 
{ 
//撤销对DataTable的更改 
myset.Tables[0].RejectChanges(); 
} 
} 
}