c#写的一个连接数据库的小程序

using System;

using System.Collections.Generic;

using https://www.360docs.net/doc/9e12390397.html,ponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace WindowsFormsApplication1

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)

{

}

private void dataGridView1_RowEnter(object sender, DataGridViewCellEventArgs e)

{

}

private void Form1_Load(object sender, EventArgs e)

{

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

this.studentTableAdapter.Fill(this.mmessageDataSet.student);

}

private void textBox1_TextChanged(object sender, EventArgs e)

{

}

private void textBox2_TextChanged(object sender, EventArgs e)

{

}

private void textBox3_TextChanged(object sender, EventArgs e)

{

}

private void button1_Click(object sender, EventArgs e)

{

try

{

SqlConnection thisConnection = new SqlConnection("Data Source=(local);DataBase=Mmessage;Integrated Security=SSPI");

SqlDataAdapter thisAdapter = new SqlDataAdapter();

DataSet thisDataSet = new DataSet();

SqlCommand thisCommand = new SqlCommand("select studentid ,studentname ,score from student", thisConnection);

SqlCommand up = new SqlCommand("insert into student ( studentid,studentname,score) values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "')", thisConnection);

thisAdapter.SelectCommand = thisCommand;

thisConnection.Open();

up.ExecuteNonQuery();

thisAdapter.Fill(thisDataSet, "student");

MessageBox.Show("成功添加信息");

thisConnection.Close();

dataGridView1.DataSource = thisDataSet.Tables["student"];

}

catch (Exception eee) { }

}

private void button2_Click(object sender, EventArgs e)

{

SqlCommand cmd = new SqlCommand();

cmd.Connection = new SqlConnection("Data Source=(local);DataBase=Mmessage;Integrated Security=SSPI");

https://www.360docs.net/doc/9e12390397.html,mandText = "delete from student where studentid = '" + textBox1.Text.Trim() + "'";

if (MessageBox.Show("你确定删除该行么？" + https://www.360docs.net/doc/9e12390397.html,mandText + "", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)

{

try

{

cmd.Connection.Open();

cmd.ExecuteNonQuery();

cmd.Connection.Close();

MessageBox.Show("删除成功！");

}

catch (Exception ee)

{

MessageBox.Show(ee.ToString());

}

finally

{

cmd.Dispose();

}

}

}

private void button3_Click(object sender, EventArgs e)

{

try

{

SqlConnection thisConnection = new SqlConnection("Data Source=(local);DataBase=Mmessage;Integrated Security=SSPI");

SqlDataAdapter thisAdapter = new SqlDataAdapter();

DataSet thisDataSet = new DataSet();

SqlCommand thisCommand = new SqlCommand("select studentid ,studentname ,score from student", thisConnection);

SqlCommand up = new SqlCommand("update student set studentid='" +

textBox1.Text + "',studentname='" + textBox2.Text + "',score='" + textBox3.Text + "'where studentid='" + dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value.ToString() + "'", thisConnection);

thisAdapter.SelectCommand = thisCommand;

thisConnection.Open();

up.ExecuteNonQuery();

thisAdapter.Fill(thisDataSet, "student");

MessageBox.Show("成功修改信息");

thisConnection.Close();

dataGridView1.DataSource = thisDataSet.Tables["student"];

}

catch (Exception eee) { }

}

private void dataGridView1_SelectionChanged(object sender, EventArgs e)

{

try

{

textBox1.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value.ToString();

textBox2.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[1].Value.ToString();

textBox3.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[2].Value.ToString();

}

catch { }

}

}

}