基本信息
源码名称:C# 简单学生管理系统(含数据库)
源码大小:0.76M
文件格式:.rar
开发语言:C#
更新时间:2018-07-20
友情提示:(无需注册或充值,赞助后即可获取资源下载链接)
嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):813200300
本次赞助数额为: 4 元×
微信扫码支付:4 元
×
请留下您的邮箱,我们将在2小时内将文件发到您的邮箱
源码介绍
实现简单数据库增删改查等功能
private void button2_Click(object sender, EventArgs e)
{
da = new SqlDataAdapter();
MyDataSet = new DataSet();
string sql = "select * from stu_info";
da.SelectCommand = new SqlCommand(sql, conn);
SqlCommandBuilder myCB = new SqlCommandBuilder(da);
da.Fill(MyDataSet, "mytable");
for (int i = 0; i < MyDataSet.Tables["mytable"].Rows.Count - 1; i )
{
if (MyDataSet.Tables["mytable"].Rows[i]["xh"].ToString().Trim() == textBox1.Text.Trim())
{
MyDataSet.Tables["mytable"].Rows[i]["xm"] = textBox3.Text;
MyDataSet.Tables["mytable"].Rows[i]["stu_mima"] = textBox4.Text;
MyDataSet.Tables["mytable"].Rows[i]["xb"] = comboBox1.Text;
MyDataSet.Tables["mytable"].Rows[i]["age"] = textBox5.Text;
MyDataSet.Tables["mytable"].Rows[i]["jg"] = textBox6.Text;
MyDataSet.Tables["mytable"].Rows[i]["phone"] = textBox7.Text;
MyDataSet.Tables["mytable"].Rows[i]["qq"] = textBox8.Text;
MyDataSet.Tables["mytable"].Rows[i]["jtdz"] = textBox9.Text;
}
}
if(MyDataSet.HasChanges())
{
da.Update(MyDataSet, "mytable");
MessageBox.Show("修改成功!", "提示");
}
实现简单数据库增删改查等功能
private void button2_Click(object sender, EventArgs e)
{
da = new SqlDataAdapter();
MyDataSet = new DataSet();
string sql = "select * from stu_info";
da.SelectCommand = new SqlCommand(sql, conn);
SqlCommandBuilder myCB = new SqlCommandBuilder(da);
da.Fill(MyDataSet, "mytable");
for (int i = 0; i < MyDataSet.Tables["mytable"].Rows.Count - 1; i )
{
if (MyDataSet.Tables["mytable"].Rows[i]["xh"].ToString().Trim() == textBox1.Text.Trim())
{
MyDataSet.Tables["mytable"].Rows[i]["xm"] = textBox3.Text;
MyDataSet.Tables["mytable"].Rows[i]["stu_mima"] = textBox4.Text;
MyDataSet.Tables["mytable"].Rows[i]["xb"] = comboBox1.Text;
MyDataSet.Tables["mytable"].Rows[i]["age"] = textBox5.Text;
MyDataSet.Tables["mytable"].Rows[i]["jg"] = textBox6.Text;
MyDataSet.Tables["mytable"].Rows[i]["phone"] = textBox7.Text;
MyDataSet.Tables["mytable"].Rows[i]["qq"] = textBox8.Text;
MyDataSet.Tables["mytable"].Rows[i]["jtdz"] = textBox9.Text;
}
}
if(MyDataSet.HasChanges())
{
da.Update(MyDataSet, "mytable");
MessageBox.Show("修改成功!", "提示");
}