C#常用增删改查源码.docx
- 文档编号:13292083
- 上传时间:2023-06-12
- 格式:DOCX
- 页数:17
- 大小:16.41KB
C#常用增删改查源码.docx
《C#常用增删改查源码.docx》由会员分享,可在线阅读,更多相关《C#常用增删改查源码.docx(17页珍藏版)》请在冰点文库上搜索。
C#常用增删改查源码
这个是添加的代码
usingSystem;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Text;
namespace学生成绩管理系统
{
publicpartialclassstudentluru:
Form
{
//CurrencyManagercmAmend;
//SqlConnectionsqlConnection1=newSqlConnection();
publicstudentluru()
{
InitializeComponent();
}
privatevoidstudentluru_Load(objectsender,EventArgse)
{
}
//录入
privatevoidbutton5_Click(objectsender,EventArgse)
{
stringsno=textBox1.Text;
stringsname=textBox2.Text;
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=="")
{
if(textBox1.Text=="")
{
MessageBox.Show("学号不能为空","警告提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Error);
textBox1.Focus();
return;
}
if(textBox2.Text=="")
{
MessageBox.Show("姓名不能为空","警告提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Error);
textBox2.Focus();
return;
}
if(textBox5.Text=="")
{
MessageBox.Show("班级不能为空","警告提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Error);
textBox5.Focus();
return;
}
}
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="";
MessageBox.Show("数据已经添加成功","温馨提示");
conn.Close();
}
catch(Exceptionex)
{
MessageBox.Show(ex.ToString());
}
}
}
privatevoidbutton8_Click(objectsender,EventArgse)
{
this.Dispose();
}
}
}
这个是查询界面的代码:
usingSystem;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Text;
namespace学生成绩管理系统
{
publicpartialclassstudentchaxun:
Form
{
DataTabledt=newDataTable();
stringper;
stringsno;
CurrencyManagercmAmend;
publicstudentchaxun()
{
InitializeComponent();
}
publicstudentchaxun(stringk,strings)
{
InitializeComponent();
per=k;
sno=s;
}
privatevoidstudentchaxun_Load(objectsender,EventArgse)
{
//TODO:
这行代码将数据加载到表“studentDataSet.studentinfo”中。
您可以根据需要移动或移除它。
//数据绑定
if(per=="超级用户")
{
stringsqlsel="select*fromstudentinfo";
DataTabledt=bangding(sqlsel);
cmAmend=(CurrencyManager)BindingContext[dt];
}
if(per=="普通用户")
{
stringsqlsel="select*fromstudentinfowheresno='"+sno+"'";
DataTabledt=bangding(sqlsel);
cmAmend=(CurrencyManager)BindingContext[dt];
}
}
DataTablebangding(stringsqlsel)
{
stringconnstr="server=.;uid=sa;pwd=sa;database=sc";
using(SqlConnectionconn=newSqlConnection(connstr))
{
conn.Open();
DataSetds=newDataSet();
SqlDataAdapterda=newSqlDataAdapter(sqlsel,conn);
da.Fill(ds,"coust");
DataTabledt=ds.Tables["coust"];
conn.Close();
returndt;
}
}
privatevoidbutton1_Click(objectsender,EventArgse)
{
{
stringxuehao=comboBox1.Text;
stringsqlsel="select*fromstudentinfowheresno='"+xuehao+"'";
}
else
{
stringxingming=comboBox2.Text;
stringsqlsel="select*fromstudentinfowheresname='"+xingming+"'";
}
}
privatevoidradioButton1_CheckedChanged(objectsender,EventArgse)
{
{
}
else
{
}
}
privatevoidcheckstate(intpos)
{
if(pos==0)
{
toolStripButton1.Enabled=false;
toolStripButton2.Enabled=false;
toolStripButton3.Enabled=true;
toolStripButton4.Enabled=true;
}
else
{
toolStripButton1.Enabled=true;
toolStripButton2.Enabled=true;
toolStripButton3.Enabled=true;
toolStripButton4.Enabled=true;
}
}
//首记录
privatevoidtoolStripButton1_Click(objectsender,EventArgse)
{
cmAmend.Position=0;//设置为0.回到首记录
checkstate(cmAmend.Position);
}
//上一条
privatevoidtoolStripButton2_Click(objectsender,EventArgse)
{
cmAmend.Position--;
checkstate(cmAmend.Position);
}
//下一条
privatevoidtoolStripButton3_Click(objectsender,EventArgse)
{
cmAmend.Position++;
checkstate(cmAmend.Position);
}
//末记录
privatevoidtoolStripButton4_Click(objectsender,EventArgse)
{
cmAmend.Position=cmAmend.Count-1;
checkstate(cmAmend.Position);
}
}
}
删除的代码:
usingSystem;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Text;
namespace学生成绩管理系统
{
publicpartialclassstudentshanchu:
Form
{
CurrencyManagercmAmend;
publicstudentshanchu()
{
InitializeComponent();
}
privatevoidstudentshanchu_Load(objectsender,EventArgse)
{
//TODO:
这行代码将数据加载到表“studentDataSet.studentinfo”中。
您可以根据需要移动或移除它。
//数据绑定
stringsqlsel="select*fromstudentinfo";
DataTabledt=bangding(sqlsel);
cmAmend=(CurrencyManager)BindingContext[dt];
}
DataTablebangding(stringsqlsel)
{
stringconnstr="server=.;uid=sa;pwd=sa;database=sc";
using(SqlConnectionconn=newSqlConnection(connstr))
{
conn.Open();
DataSetds=newDataSet();
SqlDataAdapterda=newSqlDataAdapter(sqlsel,conn);
da.Fill(ds,"coust");
DataTabledt=ds.Tables["coust"];
conn.Close();
returndt;
}
}
privatevoidcheckBox1_CheckedChanged(objectsender,EventArgse)
{
if(checkBox1.Checked==true)
{this.Height=450;}
else
{this.Height=250;}
}
privatevoidbutton1_Click(objectsender,EventArgse)
{
if(MessageBox.Show("你确定要删除该记录吗","询问",MessageBoxButtons.OKCancel,MessageBoxIcon.Question)==DialogResult.OK)
{
stringconnstr="server=.;uid=sa;pwd=sa;database=sc";
using(SqlConnectionconn=newSqlConnection(connstr))
{
conn.Open();
DataSetds=newDataSet();
stringsqlset="select*fromstudentinfo";
//数据集
SqlDataAdapterda=newSqlDataAdapter(sqlset,conn);
da.Fill(ds,"coust");
DataTabledt=ds.Tables["coust"];
SqlCommandBuildercb=newSqlCommandBuilder(da);
dt.Rows[pos].Delete();
da.Update(ds,"coust");
textBox1.Text="";
textBox2.Text="";
textBox3.Text="";
textBox4.Text="";
textBox5.Text="";
textBox6.Text="";
textBox7.Text="";
textBox8.Text="";
textBox9.Text="";
MessageBox.Show("恭喜你已成功删除","温馨提示");
conn.Close();
}
}
}
}
}
修改的代码:
usingSystem;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Text;
namespace学生成绩管理系统
{
publicpartialclassstudentxiugai:
Form
{
stringconnstr="server=.;uid=sa;pwd=sa;database=sc";
stringper;
stringsno;
CurrencyManagercmAmend;
publicstudentxiugai()
{
InitializeComponent();
}
publicstudentxiugai(stringk,strings)
{
InitializeComponent();
per=k;
sno=s;
}
privatevoidcheckBox1_CheckedChanged(objectsender,EventArgse)
{
if(checkBox1.Checked==true)
{//this.Height=450;
comboBox1.Enabled=false;
textBox1.Enabled=false;
}
else
{//this.Height=250;
comboBox1.Enabled=true;
textBox1.Enabled=true;
}
}
privatevoidstudentxiugai_Load(objectsender,EventArgse)
{
//数据绑定
if(per=="超级用户")
{
stringsqlsel="select*fromstudentinfoorderbysnoasc";
DataTabledt=bangding(sqlsel);
cmAmend=(CurrencyManager)BindingContext[dt];
}
if(per=="普通用户")
{
stringsqlsel="select*fromstudentinfowheresno='"+sno+"'";
DataTabledt=bangding(sqlsel);
}
}
DataTablebangding(stringsqlsel)
{
//stringconnstr="server=.;uid=sa;pwd=sa;database=sc";
using(SqlConnectionconn=newSqlConnection(connstr))
{
conn.Open();
DataSetds=newDataSet();
SqlDataAdapterda=newSqlDataAdapter(sqlsel,conn);
da.Fill(ds,"coust");
DataTabledt=ds.Tables["coust"];
conn.Close();
returndt;
}
}
privatevoidbutton1_Click(objectsender,EventArgse)
{
if(checkBox1.Checked==true)
{
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;
if(textBox2.Text==""||textBox3.Text==""||textBox4.Text==""||textBox5.Text=="")
{
if(textBox2.Text=="")
{
MessageBox.Show("性别不能为空","温馨提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Error);
textBox2.Focus();
return;
}
if(textBox3.Text=="")
{
MessageBox.Show("年龄不能为空","温馨提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Error);
textBox3.Focus();
return;
}
if(textBox4.Text=="")
{
MessageBox.Show("班级不能为空","温馨提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Error);
textBox4.Focus();
return;
}
if(textBox5.Text=="")
{
MessageBox.Show("系别不能为空","温馨提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Error);
textBox5.Focus();
return;
}
}
else
{
stringconnstr="server=IT32;uid=sa;pwd='sa';database=sc;";
try
{
SqlConnectionconn=newSqlConnection(connstr);
conn.Open();
stringsqlupdate="updatestudentinfosetssex='"+sex+"',sage='"+age+"',sclass='"+sclass+"',sdept='"+sdept+"',saddress='"+saddress+"',sphone='"+sphone+"',sqq='"+sqq+"'wheresno='"+sno+"'";
SqlCommandsc=newSqlCommand(sqlupdate,conn);
sc.ExecuteNonQuery();
MessageBox.Show("数据已经修改成功","温馨提示");
conn.Close();
}
catch(Exceptionex)
{
MessageBox.Show(ex.ToString());
}
}
}
else
{
MessageBox.Show("对不起,你还没
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- C# 常用 增删 源码