C数据库基本操作.docx
源代码如下：
usingSystem;
usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;
usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
namespace实验二
{
publicpartialclassForm1:Form
{
publicForm1()
{
InitializeComponent();
}
privatevoidbutton1_Click(objectsender,EventArgse)
{
stringconnectionString=@DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\StudentDB.mdf;IntegratedSecurity=True;ConnectTimeout=30;UserInstance=True;
SqlConnectioncon=newSqlConnection();con.ConnectionString=connectionString;try
{
con.Open();
rtbMessge.Text=连接数据库+con.Database+连接成功!连接字符串如下：\n+con.ConnectionString;
}
catch(Exceptionex)
{
rtbMessge.Text=ex.Message;
}
finally
{
con.Close();
}
}
privatevoidbutton2_Click(objectsender,EventArgse)
{
stringconnectionString=@DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\StudentDB.mdf;IntegratedSecurity=True;ConnectTimeout=30;UserInstance=True;
SqlConnectioncon=newSqlConnection();
con.ConnectionString=connectionString;stringcmdText=select*fromData;SqlCommandcmd=newSqlCommand(cmdText,con);
try
{
con.Open();
SqlDataReaderdr=cmd.ExecuteReader();rtbMessge.Text=读取的数据如下：\n;while(dr.Read())
{
for(inti=0;idr.FieldCount;i++)
{
rtbMessge.Text+=dr[i].ToString()+\t;
}
rtbMessge.Text+=\n;
}
dr.Close();
}
catch(Exceptionex)
{
rtbMessge.Text=ex.Message;
}
finally
{
con.Close();
}
}
privatevoidbutton3_Click(objectsender,EventArgse)
{
stringconnectionString=@DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\StudentDB.mdf;IntegratedSecurity=True;ConnectTimeout=30;UserInstance=True;
SqlConnectioncon=newSqlConnection();con.ConnectionString=connectionString;
stringcmdText=INSERTData(sno,sname,sdept,sex,sage)VALUES(96012,李大,CS,
男,20);
SqlCommandcmd=newSqlCommand(cmdText,con);try
{
con.Open();cmd.ExecuteNonQuery();
}
catch(Exceptionex)
{
rtbMessg