当前位置:文档之家› C#常用增删改查源码

C#常用增删改查源码

C#常用增删改查源码
C#常用增删改查源码

这个是添加的代码

using System;

using System.Collections.Generic;

using https://www.doczj.com/doc/5c17611020.html,ponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace 学生成绩管理系统

{

public partial class studentluru : Form

{

// CurrencyManager cmAmend;

// SqlConnection sqlConnection1 = new SqlConnection();

public studentluru()

{

InitializeComponent();

}

private void studentluru_Load(object sender, EventArgs e)

{

}

//录入

private void button5_Click(object sender, EventArgs e)

{

string sno = textBox1.Text;

string sname = textBox2.Text;

string ssex = textBox3.Text;

string sage = textBox4.Text;

string sclass = textBox5.Text;

string sdept = textBox6.Text;

string saddress = textBox7.Text;

string sphone = textBox8.Text;

string sqq = 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

{

string connstr = "server=IT32;uid=sa;pwd='sa';database=sc;";

try

{

SqlConnection conn = new SqlConnection(connstr);

conn.Open();

string sqlinsert = "insert into studentinfo values('" + sno + "','" + sname + "','" + ssex + "','" + sage + "','" + sclass + "','" + sdept + "','" + saddress + "','" + sphone + "','" + sqq + "')";

SqlCommand sc = new SqlCommand(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 (Exception ex)

{

MessageBox.Show(ex.ToString());

}

}

}

private void button8_Click(object sender, EventArgs e) {

this.Dispose();

}

}

}

这个是查询界面的代码:

using System;

using System.Collections.Generic;

using https://www.doczj.com/doc/5c17611020.html,ponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace 学生成绩管理系统

{

public partial class studentchaxun : Form

{

DataTable dt = new DataTable();

string per;

string sno;

CurrencyManager cmAmend;

public studentchaxun()

{

InitializeComponent();

}

public studentchaxun(string k, string s)

{

InitializeComponent();

per = k;

sno = s;

}

private void studentchaxun_Load(object sender, EventArgs e)

{

// TODO: 这行代码将数据加载到表“studentDataSet.studentinfo”中。您可以根据需要移动或移除它。

//this.studentinfoTableAdapter.Fill(this.studentDataSet.studentinfo);

//数据绑定

if (per == "超级用户")

{

string sqlsel = "select * from studentinfo ";

DataTable dt = bangding(sqlsel);

cmAmend = (CurrencyManager)BindingContext[dt];

this.dataGridView1.DataSource = dt;

https://www.doczj.com/doc/5c17611020.html,boBox1.DataSource = dt;

https://www.doczj.com/doc/5c17611020.html,boBox1.DisplayMember = "sno";

https://www.doczj.com/doc/5c17611020.html,boBox2.DataSource = dt;

https://www.doczj.com/doc/5c17611020.html,boBox2.DisplayMember = "sname";

}

if (per == "普通用户")

{

string sqlsel = "select * from studentinfo where sno='" + sno + "' "; DataTable dt = bangding(sqlsel);

cmAmend = (CurrencyManager)BindingContext[dt];

this.dataGridView1.DataSource = dt;

https://www.doczj.com/doc/5c17611020.html,boBox1.DataSource = dt;

https://www.doczj.com/doc/5c17611020.html,boBox1.DisplayMember = "sno";

https://www.doczj.com/doc/5c17611020.html,boBox2.Enabled = false;

this.radioButton2.Enabled = false;

//this.toolStripButton1.Enabled = false;

//this.toolStripButton2.Enabled = false;

//this.toolStripButton3.Enabled = false;

//this.toolStripButton4.Enabled = false;

//https://www.doczj.com/doc/5c17611020.html,boBox2.DataSource = dt;

//https://www.doczj.com/doc/5c17611020.html,boBox2.DisplayMember = "sname";

}

}

DataTable bangding(string sqlsel)

{

string connstr = "server=.;uid=sa;pwd=sa;database=sc";

using (SqlConnection conn = new SqlConnection(connstr))

{

conn.Open();

DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter(sqlsel, conn);

da.Fill(ds, "coust");

DataTable dt = ds.Tables["coust"];

conn.Close();

return dt;

}

}

private void button1_Click(object sender, EventArgs e)

{

if (this.radioButton1.Checked == true)

{

string xuehao = comboBox1.Text;

string sqlsel = "select * from studentinfo where sno='" + xuehao + "'"; this.dataGridView1.DataSource = bangding(sqlsel);

}

else

{

string xingming = comboBox2.Text;

string sqlsel = "select * from studentinfo where sname='" + xingming + "'"; this.dataGridView1.DataSource = bangding(sqlsel);

}

}

private void radioButton1_CheckedChanged(object sender, EventArgs e)

{

if (this.radioButton1.Checked == true)

{

https://www.doczj.com/doc/5c17611020.html,boBox1.Enabled = true;

https://www.doczj.com/doc/5c17611020.html,boBox2.Enabled = false;

}

else

{

https://www.doczj.com/doc/5c17611020.html,boBox1.Enabled = false;

https://www.doczj.com/doc/5c17611020.html,boBox2.Enabled = true;

}

}

private void checkstate(int pos)

{

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;

}

}

//首记录

private void toolStripButton1_Click(object sender, EventArgs e) {

cmAmend.Position = 0;//设置为0.回到首记录

this.dataGridView1.Select();

checkstate(cmAmend.Position);

}

//上一条

private void toolStripButton2_Click(object sender, EventArgs e) {

cmAmend.Position--;

this.dataGridView1.Select();

checkstate(cmAmend.Position);

}

//下一条

private void toolStripButton3_Click(object sender, EventArgs e) {

cmAmend.Position++;

this.dataGridView1.Select();

checkstate(cmAmend.Position);

}

//末记录

private void toolStripButton4_Click(object sender, EventArgs e) {

cmAmend.Position = cmAmend.Count - 1;

this.dataGridView1.Select();

checkstate(cmAmend.Position);

}

}

}

删除的代码:

using System;

using System.Collections.Generic;

using https://www.doczj.com/doc/5c17611020.html,ponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace 学生成绩管理系统

{

public partial class studentshanchu : Form

{

CurrencyManager cmAmend;

public studentshanchu()

{

InitializeComponent();

}

private void studentshanchu_Load(object sender, EventArgs e)

// TODO: 这行代码将数据加载到表“studentDataSet.studentinfo”中。您可以根据需要移动或移除它。

//this.studentinfoTableAdapter.Fill(this.studentDataSet.studentinfo);

//数据绑定

string sqlsel = "select * from studentinfo ";

DataTable dt = bangding(sqlsel);

cmAmend = (CurrencyManager)BindingContext[dt];

this.dataGridView1.DataSource = dt;

this.textBox1.DataBindings.Add("text", dt, "sno");

this.textBox2.DataBindings.Add("text", dt, "sname");

this.textBox3.DataBindings.Add("text", dt, "ssex");

this.textBox4.DataBindings.Add("text", dt, "sage");

this.textBox5.DataBindings.Add("text", dt, "sclass");

this.textBox6.DataBindings.Add("text", dt, "sdept");

this.textBox7.DataBindings.Add("text", dt, "saddress");

this.textBox8.DataBindings.Add("text", dt, "sphone");

this.textBox9.DataBindings.Add("text", dt, "sqq");

}

DataTable bangding(string sqlsel)

{

string connstr = "server=.;uid=sa;pwd=sa;database=sc";

using (SqlConnection conn = new SqlConnection(connstr))

{

conn.Open();

DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter(sqlsel, conn);

da.Fill(ds, "coust");

DataTable dt = ds.Tables["coust"];

conn.Close();

return dt;

}

}

private void checkBox1_CheckedChanged(object sender, EventArgs e)

{

if (checkBox1.Checked == true)

{ this.Height = 450; }

else

{ this.Height = 250; }

}

private void button1_Click(object sender, EventArgs e)

{

if (MessageBox.Show("你确定要删除该记录吗", "询问", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)

{

int pos = this.dataGridView1.CurrentCell.RowIndex; //获取该行

string connstr = "server=.;uid=sa;pwd=sa;database=sc";

using (SqlConnection conn = new SqlConnection(connstr))

{

conn.Open();

DataSet ds = new DataSet();

string sqlset = "select * from studentinfo";

//数据集

SqlDataAdapter da = new SqlDataAdapter(sqlset, conn);

da.Fill(ds, "coust");

DataTable dt = ds.Tables["coust"];

SqlCommandBuilder cb = new SqlCommandBuilder(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 = "";

this.dataGridView1.DataSource = bangding(sqlset);

MessageBox.Show("恭喜你已成功删除","温馨提示");

conn.Close();

}

}

}

}

}

修改的代码:

using System;

using System.Collections.Generic;

using https://www.doczj.com/doc/5c17611020.html,ponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace 学生成绩管理系统

{

public partial class studentxiugai : Form

{

string connstr = "server=.;uid=sa;pwd=sa;database=sc";

string per;

string sno;

CurrencyManager cmAmend;

public studentxiugai()

{

InitializeComponent();

}

public studentxiugai(string k,string s)

{

InitializeComponent();

per = k;

sno = s;

}

private void checkBox1_CheckedChanged(object sender, EventArgs e) {

if (checkBox1.Checked == true)

{ //this.Height = 450;

comboBox1.Enabled = false;

textBox1.Enabled = false;

}

else

{ //this.Height = 250;

comboBox1.Enabled = true;

textBox1.Enabled = true;

}

}

private void studentxiugai_Load(object sender, EventArgs e)

{

//数据绑定

if (per == "超级用户")

{

string sqlsel = "select * from studentinfo order by sno asc "; DataTable dt = bangding(sqlsel);

cmAmend = (CurrencyManager)BindingContext[dt];

https://www.doczj.com/doc/5c17611020.html,boBox1.DataSource = dt;

https://www.doczj.com/doc/5c17611020.html,boBox1.DisplayMember = "sno";

this.textBox1.DataBindings.Add("text", dt, "sname");

this.textBox2.DataBindings.Add("text", dt, "ssex");

this.textBox3.DataBindings.Add("text", dt, "sage");

this.textBox4.DataBindings.Add("text", dt, "sclass");

this.textBox5.DataBindings.Add("text", dt, "sdept");

this.textBox6.DataBindings.Add("text", dt, "saddress");

this.textBox7.DataBindings.Add("text", dt, "sphone");

this.textBox8.DataBindings.Add("text", dt, "sqq");

}

if (per == "普通用户")

{

string sqlsel = "select *from studentinfo where sno='" + sno + "'"; DataTable dt = bangding(sqlsel);

https://www.doczj.com/doc/5c17611020.html,boBox1.DataSource = dt;

https://www.doczj.com/doc/5c17611020.html,boBox1.DisplayMember = "sno";

this.textBox1.DataBindings.Add("text", dt, "sname");

this.textBox2.DataBindings.Add("text", dt, "ssex");

this.textBox3.DataBindings.Add("text", dt, "sage");

this.textBox4.DataBindings.Add("text", dt, "sclass");

this.textBox5.DataBindings.Add("text", dt, "sdept");

this.textBox6.DataBindings.Add("text", dt, "saddress");

this.textBox7.DataBindings.Add("text", dt, "sphone");

this.textBox8.DataBindings.Add("text", dt, "sqq");

}

}

DataTable bangding(string sqlsel)

{

// string connstr = "server=.;uid=sa;pwd=sa;database=sc";

using (SqlConnection conn = new SqlConnection(connstr))

{

conn.Open();

DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter(sqlsel, conn);

da.Fill(ds, "coust");

DataTable dt = ds.Tables["coust"];

conn.Close();

return dt;

}

}

private void button1_Click(object sender, EventArgs e)

{

if (checkBox1.Checked == true)

{

string sno = comboBox1.Text;

string sname = textBox1.Text;

string sex = textBox2.Text;

string age = textBox3.Text;

string sclass = textBox4.Text;

string sdept = textBox5.Text;

string saddress = textBox6.Text;

string sphone = textBox7.Text;

string sqq = 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

{

string connstr = "server=IT32;uid=sa;pwd='sa';database=sc;";

try

{

SqlConnection conn = new SqlConnection(connstr);

conn.Open();

string sqlupdate = " update studentinfo set ssex='" + sex + "',sage='" + age + "',sclass='" + sclass + "',sdept='" + sdept + "',saddress='" + saddress + "',sphone='" + sphone + "',sqq='" + sqq + "' where sno='" + sno + "'";

SqlCommand sc = new SqlCommand(sqlupdate, conn);

sc.ExecuteNonQuery();

MessageBox.Show("数据已经修改成功", "温馨提示");

conn.Close();

}

catch (Exception ex)

{

MessageBox.Show(ex.ToString());

}

}

}

else

{

MessageBox.Show("对不起,你还没有选中'我要修改',所以您无法修改","温馨提示");

}

}

}

相关主题
相关文档 最新文档