|
|
| 增改删查 |
|
|
|
|
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Data.SqlClient;
usingSystem.Configuration;
namespaceselectinfo
{
classProgram
{
staticvoidMain(string[]args)
{
SqlConnectionconnection=newSqlConnection();
stringconnstr=ConfigurationManager.ConnectionStrings["DataBase"].ToString();
connection.ConnectionString=connstr;
connection.Open();
SqlCommandcmd=newSqlCommand("selectID,name,sex,classIDfromStudent",connection);
SqlDataReaderreader=cmd.ExecuteReader();
if(reader.HasRows)
{
while(reader.Read())
{
Console.WriteLine(string.Format("ID:{0}\nname:{1}\nsex:{2}\nclaaID:{3}",reader[0],reader[1],reader[2],reader[3]));
}
reader.Close();
}
else
{
Console.WriteLine("没有数据");
}
connection.Close();
Console.Read();
}
}
}
usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
usingSystem.Configuration;
namespace_2222
{
publicpartialclassForm1:Form
{
publicForm1()
{
InitializeComponent();
}
privatevoidbtnSave_Click(objectsender,EventArgse)
{
if(txtClassID.Text==""||txtId.Text==""||txtName.Text=="")
MessageBox.Show("请输入数据，不允许有空");
else
{
SqlConnectionconnection=newSqlConnection();
stringconnstr=ConfigurationManager.ConnectionStrings["DataBase"].ToString();
connection.ConnectionString=connstr;
connection.Open();
SqlCommandcmd=newSqlCommand("insertintoStudent(ID,name,sex,classID)values(@ID,@name,@sex,@classID)",connection);
cmd.Parameters.Add("@ID",SqlDbType.NChar);
cmd.Parameters["@ID"].Value=this.txtId.Text.Trim();
cmd.Parameters.Add("@name",SqlDbType.NChar);
cmd.Parameters["@name"].Value=this.txtName.Text.Trim();
cmd.Parameters.Add("@sex",SqlDbType.NChar);
if(btnFeman.Checked==false&&btnMan.Checked==false)
MessageBox.Show("请选择性别");
else
{
if(btnMan.Checked)
{
cmd.Parameters["@sex"].Value=this.btnMan.Text.Trim();
cmd.Parameters.Add("@classID",SqlDbType.NChar);
cmd.Parameters["@classID"].Value=this.txtClassID.Text.Trim();
inti=cmd.ExecuteNonQuery();
connection.Close();
if(i>0)
MessageBox.Show("已插入，保存成功");
else
MessageBox.Show("插入保存失败");
}
else
{
cmd.Parameters["@sex"].Value=this.btnFeman.Text.Trim();
cmd.Parameters.Add("@classID",SqlDbType.NChar);
cmd.Parameters["@classID"].Value=this.txtClassID.Text.Trim();
inti=cmd.ExecuteNonQuery();
connection.Close();
if(i>0)
MessageBox.Show("已插入，保存成功");
else
MessageBox.Show("插入保存失败");
}
}
}
}
}
}
usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
usingSystem.Configuration;
namespace_3333
{
publicpartialclassForm1:Form
{
publicForm1()
{
InitializeComponent();
}
privatevoidbtnDSelect_Click(objectsender,EventArgse)
{
SqlConnectionconnection=newSqlConnection();
stringconnstr=ConfigurationManager.ConnectionStrings["DataBase"].ToString();
connection.ConnectionString=connstr;
connection.Open();
SqlCommandcmd=newSqlCommand("selectID,name,sex,classIDfromStudent",connection);
SqlDataAdapteradp=newSqlDataAdapter();
adp.SelectCommand=cmd;
DataSetse=newDataSet();
adp.Fill(se,"Student");
this.dataGridView1.DataSource=se.Tables["Student"];
}
}
}
usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
usingSystem.Configuration;
namespace_4444
{
publicpartialclassForm1:Form
{
publicForm1()
{
InitializeComponent();
}
intflag=0;
privatevoidbtnDataSet_Click(objectsender,EventArgse)
{
try
{
if(txtName.Text==""||txtID.Text==""||txtClassid.Text=="")
MessageBox.Show("请输入数据，不允许有空");
else
{
SqlConnectionconnection=newSqlConnection();
stringconnstr=ConfigurationManager.ConnectionStrings["DataBase"].ToString();
connection.ConnectionString=connstr;
connection.Open();
SqlCommandcmd=newSqlCommand("selectID,name,sex,classIDfromStudent",connection);
SqlDataAdapteradp=newSqlDataAdapter();
adp.SelectCommand=cmd;
DataSetse=newDataSet();
adp.Fill(se,"Student");
SqlCommandBuilderbuilder=newSqlCommandBuilder(adp);
DataTabledt=se.Tables["Student"];
DataRowrow=dt.NewRow();
row["ID"]=this.txtID.Text.Trim();
row["name"]=this.txtName.Text.Trim();
row["classID"]=this.txtClassid.Text.Trim();
if(btnFeman.Checked==false&&btnMan.Checked==false)
MessageBox.Show("请选择性别");
else
{
if(btnMan.Checked)
{
row["sex"]=this.btnMan.Text.Trim();
dt.Rows.Add(row);
adp.Update(se,"Student");
}
else
{
row["sex"]=this.btnFeman.Text.Trim();
dt.Rows.Add(row);
adp.Update(se,"Student");
}
}
}
}
catch(SqlExceptionex)
{
flag=1;
MessageBox.Show(ex.Message);
}
finally
{
if(flag==0)
MessageBox.Show("Sucessed");
}
}
}
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
