C#进行Sql server数据库增删查改操作.docVIP

C#连接SQL Server数据库并进行增删查改操作 详细代码在下边，直接可以使用 设计好的C#界面： 共3个窗体。 数据库： 运行后的界面： 代码： （Form1） public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { Form1_Load(sender, e); } private void Form1_Load(object sender, EventArgs e) { try { SqlConnection conn = new SqlConnection(); string str = Data Source=ZWEIQUAN-PC;Initial Catalog=Student;Integrated Security=True; conn.ConnectionString = str; conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = select * from 基本信息表; cmd.Connection = conn; SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds, 基本信息表); this.dataGridView1.DataSource = ds; this.dataGridView1.DataMember = 基本信息表; this.dataGridView1.AutoGenerateColumns = true; for (int i = 1; i this.dataGridView1.ColumnCount; i++) { this.dataGridView1.Columns[i].DefaultCellStyle.SelectionBackColor = Color.White; this.dataGridView1.Columns[i].DefaultCellStyle.SelectionForeColor = Color.Black; this.dataGridView1.Columns[i].ReadOnly = true; } conn.Close(); } catch(Exception ee) { MessageBox.Show(错误：+ee.Message ,错误); } } private void button2_Click(object sender, EventArgs e) { if (this.dataGridView1.SelectedCells==null) { MessageBox.Show(请选择要删|除的项！, 错误, MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (this.d