C#数据库示例

C＃数据库编程例子

编程实例分析

namespace WindowsApplication1

{

public partial class Form1 : Form

{

private SqlConnection tempConnection = new SqlConnection("workstation

id=localhost;database=tempdb;Connect Timeout=30;Trusted_Connection=yes");

private SqlDataAdapter da;

private DataTable tblDataSource = new DataTable();

private string strSQL = "";

SqlConnection conn;

SqlCommand da1;

public Form1()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

this.strSQL = "select * from student";

this.da = new SqlDataAdapter(this.strSQL, this.tempConnection);

tblDataSource.Clear();

this.da.Fill(tblDataSource);

this.dataGridView1.DataSource = tblDataSource;

}

private void button2_Click(object sender, EventArgs e)

{

string txt1 = "workstation id=localhost;Integrated

Security=SSPI;database=tempdb;";

string txt2 =

"Insert Into Student(xh,xm,xb) Values('";

txt2 += textBox1.Text + "' , '";

txt2 += textBox2.Text + "' , '";

txt2 += textBox3.Text + "')";//最后结果要保证在TextBox中输入的内容被单引号括住 conn = new SqlConnection(txt1);

conn.Open();//打开数据库连接

da1 = new SqlCommand(txt2, conn);

da1.ExecuteNonQuery();//执行SQL语句

//textBox1.Text = "";

//textBox2.Text = "";

//textBox3.Text = "";

conn.Close();//关闭数据库连接

MessageBox.Show("插入数据成功！");

第1页下一页