c常用增删改查源码Word格式文档下载.docx
《c常用增删改查源码Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《c常用增删改查源码Word格式文档下载.docx(17页珍藏版)》请在冰点文库上搜索。
stringssex=textBox3.Text;
stringsage=textBox4.Text;
stringsclass=textBox5.Text;
stringsdept=textBox6.Text;
stringsaddress=textBox7.Text;
stringsphone=textBox8.Text;
stringsqq=textBox9.Text;
if(textBox1.Text=="
"
||textBox2.Text=="
||textBox5.Text=="
)
MessageBox.Show("
学号不能为空"
"
警告提示"
MessageBoxButtons.OKCancel,MessageBoxIcon.Error);
textBox1.Focus();
return;
if(textBox2.Text=="
姓名不能为空"
textBox2.Focus();
if(textBox5.Text=="
班级不能为空"
textBox5.Focus();
else
stringconnstr="
server=IT32;
uid=sa;
pwd='
sa'
;
database=sc;
try
SqlConnectionconn=newSqlConnection(connstr);
conn.Open();
stringsqlinsert="
insertintostudentinfovalues('
+sno+"
'
'
+sname+"
+ssex+"
+sage+"
+sclass+"
+sdept+"
+saddress+"
+sphone+"
+sqq+"
)"
SqlCommandsc=newSqlCommand(sqlinsert,conn);
sc.ExecuteNonQuery();
textBox1.Text="
textBox2.Text="
textBox3.Text="
textBox4.Text="
textBox5.Text="
textBox6.Text="
textBox7.Text="
textBox8.Text="
textBox9.Text="
数据已经添加成功"
温馨提示"
);
conn.Close();
catch(Exceptionex)
MessageBox.Show(ex.ToString());
privatevoidbutton8_Click(objectsender,EventArgse)
this.Dispose();
这个是查询界面的代码:
usingSystem.Collections.Generic;
publicpartialclassstudentchaxun:
DataTabledt=newDataTable();
stringper;
stringsno;
CurrencyManagercmAmend;
publicstudentchaxun()
publicstudentchaxun(stringk,strings)
per=k;
sno=s;
privatevoidstudentchaxun_Load(objectsender,EventArgse)
//TODO:
这行代码将数据加载到表“studentDataSet.studentinfo”中。
您可以根据需要移动或移除它。
//数据绑定
if(per=="
超级用户"
stringsqlsel="
select*fromstudentinfo"
DataTabledt=bangding(sqlsel);
cmAmend=(CurrencyManager)BindingContext[dt];
普通用户"
select*fromstudentinfowheresno='
"
DataTablebangding(stringsqlsel)
server=.;
pwd=sa;
database=sc"
using(SqlConnectionconn=newSqlConnection(connstr))
DataSetds=newDataSet();
SqlDataAdapterda=newSqlDataAdapter(sqlsel,conn);
da.Fill(ds,"
coust"
DataTabledt=ds.Tables["
];
returndt;
privatevoidbutton1_Click(objectsender,EventArgse)
stringxuehao=comboBox1.Text;
+xuehao+"
stringxingming=comboBox2.Text;
select*fromstudentinfowheresname='
+xingming+"
privatevoidradioButton1_CheckedChanged(objectsender,EventArgse)
privatevoidcheckstate(intpos)
if(pos==0)
toolStripButton1.Enabled=false;
toolStripButton2.Enabled=false;
toolStripButton3.Enabled=true;
toolStripButton4.Enabled=true;
toolStripButton1.Enabled=true;
toolStripButton2.Enabled=true;
//首记录
privatevoidtoolStripButton1_Click(objectsender,EventArgse)
cmAmend.Position=0;
//设置为0.回到首记录
checkstate(cmAmend.Position);
//上一条
privatevoidtoolStripButton2_Click(objectsender,EventArgse)
cmAmend.Position--;
//下一条
privatevoidtoolStripButton3_Click(objectsender,EventArgse)
cmAmend.Position++;
//末记录
privatevoidtoolStripButton4_Click(objectsender,EventArgse)
cmAmend.Position=cmAmend.Count-1;
删除的代码:
publicpartialclassstudentshanchu:
publicstudentshanchu()
privatevoidstudentshanchu_Load(objectsender,EventArgse)
privatevoidcheckBox1_CheckedChanged(objectsender,EventArgse)
if(checkBox1.Checked==true)
{this.Height=450;
}
{this.Height=250;
if(MessageBox.Show("
你确定要删除该记录吗"
询问"
MessageBoxButtons.OKCancel,MessageBoxIcon.Question)==DialogResult.OK)
stringsqlset="
select*fromstudentinfo"
//数据集
SqlDataAdapterda=newSqlDataAdapter(sqlset,conn);
SqlCommandBuildercb=newSqlCommandBuilder(da);
dt.Rows[pos].Delete();
da.Update(ds,"
恭喜你已成功删除"
"
修改的代码:
usingSystem.Data.SqlClient;
publicpartialclassstudentxiugai:
publicstudentxiugai()
publicstudentxiugai(stringk,strings)
{//this.Height=450;
comboBox1.Enabled=false;
textBox1.Enabled=false;
{//this.Height=250;
comboBox1.Enabled=true;
textBox1.Enabled=true;
privatevoidstudentxiugai_Load(objectsender,EventArgse)
select*fromstudentinfoorderbysnoasc"
select*fromstudentinfowheresno='
//stringconnstr="
stringsno=comboBox1.Text;
stringsname=textBox1.Text;
stringsex=textBox2.Text;
stringage=textBox3.Text;
stringsclass=textBox4.Text;
stringsdept=textBox5.Text;
stringsaddress=textBox6.Text;
stringsphone=textBox7.Text;
stringsqq=textBox8.Text;
||textBox3.Text=="
||textBox4.Text=="
性别不能为空"
if(textBox3.Text=="
年龄不能为空"
textBox3.Focus();
if(textBox4.Text=="
textBox4.Focus();
系别不能为空"
stringsqlupdate="
updatestudentinfosetssex='
+sex+"
sage='
+age+"
sclass='
sdept='
saddress='
sphone='
sqq='
wheresno='
SqlCommandsc=newSqlCommand(sqlupdate,conn);
数据已经修改成功"
MessageBox.Show