C#常用增删改查源码

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 == "")
SqlCommand sc = new SqlCommand(sqlinsert, conn);
sc.ExecuteNonQuery();
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
{
if (textBox1.Text == "")
{
MessageBox.Show("学号不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
textBox1.Focus();
return;
}
if (textBox2.Text == "")
cmAmend = (CurrencyManager)BindingContext[dt];
}
if (per == "普通用户")
{
string sqlsel = "select * from studentinfo where sno='" + sno + "' ";
DataTable dt = bangding(sqlsel);
{
cmAmend.Position--;
checkstate(cmAmend.Position);
}
//下一条
private void toolStripButton3_Click(object sender, EventArgs e)
{
cmAmend.Position++;
checkstate(cmAmend.Position);
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)
public studentchaxun()
{
InitializeComponent();
}
public studentchaxun(string k, string s)
{
InitializeComponent();
per = k;
sno = s;
}
private void studentchaxun_Load(object sender, EventArgs e)
}
//末记录
private void toolStripButton4_Click(object sender, EventArgs e)
{
cmAmend.Position = cmAmend.Count - 1;
checkstate(cmAmend.Position);
}
}
}
删除的代码:
using System;
{
string connstr = "server=.;uid=sa;pwd=sa;database=sc";
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
DataSet ds = new DataSet();
public studentshanchu()
{
InitializeComponent();
}
private void studentshanchu_Load(object sender, EventArgs e)
{
// TODO: 这行代码将数据加载到表“studentDataSet.studentinfo”中。您可以根据需要移动或移除它。
{
// TODO: 这行代码将数据加载到表“studentDataSet.studentinfo”中。您可以根据需要移动或移除它。
//数据绑定
if (per == "超级用户")
{பைடு நூலகம்
string sqlsel = "select * from studentinfo ";
DataTable dt = bangding(sqlsel);
{
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sqlsel, conn);
da.Fill(ds, "coust");
DataTable dt = ds.Tables["coust"];
conn.Close();
using System.Text;
namespace 学生成绩管理系统
{
public partial class studentchaxun : Form
{
DataTable dt = new DataTable();
string per;
string sno;
CurrencyManager cmAmend;
//数据绑定
string sqlsel = "select * from studentinfo ";
DataTable dt = bangding(sqlsel);
cmAmend = (CurrencyManager)BindingContext[dt];
}
DataTable bangding(string sqlsel)
}
}
//首记录
private void toolStripButton1_Click(object sender, EventArgs e)
{
cmAmend.Position = 0;//设置为0.回到首记录
checkstate(cmAmend.Position);
}
//上一条
private void toolStripButton2_Click(object sender, EventArgs e)
string sqlinsert = "insert into studentinfo values('" + sno + "','" + sname + "','" + ssex + "','" + sage + "','" + sclass + "','" + sdept + "','" + saddress + "','" + sphone + "','" + sqq + "')";
cmAmend = (CurrencyManager)BindingContext[dt];
}
}
DataTable bangding(string sqlsel)
{
string connstr = "server=.;uid=sa;pwd=sa;database=sc";
using (SqlConnection conn = new SqlConnection(connstr))
return dt;
}
}
private void button1_Click(object sender, EventArgs e)
{
{
string xuehao = comboBox1.Text;
string sqlsel = "select * from studentinfo where sno='" + xuehao + "'";
toolStripButton4.Enabled = true;
}
else
{
toolStripButton1.Enabled = true;
toolStripButton2.Enabled = true;
toolStripButton3.Enabled = true;
toolStripButton4.Enabled = true;
{
// CurrencyManager cmAmend;
// SqlConnection sqlConnection1 = new SqlConnection();
public studentluru()
{
InitializeComponent();
}
private void studentluru_Load(object sender, EventArgs e)
textBox5.Focus();
return;
}
}
else
{
string connstr = "server=IT32;uid=sa;pwd='sa';database=sc;";
try
{
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
{
{
}
else
{
}
}
private void checkstate(int pos)
{
if (pos == 0)
{
toolStripButton1.Enabled = false;
toolStripButton2.Enabled = false;
toolStripButton3.Enabled = true;
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
textBox9.Text = "";
MessageBox.Show("数据已经添加成功", "温馨提示");
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
else
{
string xingming = comboBox2.Text;
string sqlsel = "select * from studentinfo where sname='" + xingming + "'";
}
}
private void radioButton1_CheckedChanged(object sender, EventArgs e)
using ponentModel;
using System.Data;
using System.Drawing;
using System.Text;
namespace 学生成绩管理系统
{
public partial class studentshanchu : Form
{
CurrencyManager cmAmend;
这个是添加的代码
using System;
using ponentModel;
using System.Data;
using System.Drawing;
using System.Text;
namespace 学生成绩管理系统
{
public partial class studentluru : Form
}
}
}
private void button8_Click(object sender, EventArgs e)
{
this.Dispose();
}
}
}
这个是查询界面的代码:
using System;
using ponentModel;
using System.Data;
using System.Drawing;
{
MessageBox.Show("姓名不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
textBox2.Focus();
return;
}
if (textBox5.Text == "")
{
MessageBox.Show("班级不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
{
}
//录入
private void button5_Click(object sender, EventArgs e)
{
string sno = textBox1.Text;
string sname = textBox2.Text;
string ssex = textBox3.Text;
string sage = textBox4.Text;