usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
usingSystem.Configuration;
namespaceSaveByDataSet
{
publicpartialclassForm1:Form
{
publicForm1()
{
InitializeComponent();
}
privatevoidbtnSave_Click(objectsender,EventArgse)
{
using(SqlConnectionconn=newSqlConnection(ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString))
{
conn.Open();
SqlCommandcomm=newSqlCommand();
comm.Connection=conn;
comm.CommandText="SelectID,Name,Sex,ClassIDFromStudent";
SqlDataAdapterda=newSqlDataAdapter();
da.SelectCommand=comm;
DataSetds=newDataSet();
da.Fill(ds,"Student");
SqlCommandBuildersb=newSqlCommandBuilder(da);
DataTabledt=ds.Tables[0];
DataRowdr=dt.NewRow();
dr[0]=txtSno.Text.Trim();
dr[1]=txtName.Text.Trim();
dr[2]=txtSex.Text.Trim();
dr[3]=txtClass.Text.Trim();
dt.Rows.Add(dr);
//da.Update(ds,"Student");
if(da.Update(ds,"Student")>0)
{
MessageBox.Show("数据插入成功");
Initial();
}
else
{
MessageBox.Show("数据插入失败");
Initial();
}
}
}
privatevoidInitial()
{
txtSno.Text="";
txtSex.Text="";
txtName.Text="";
txtClass.Text="";
}
}
}
|
|