winformC#SqlServer增删改查.docVIP

//winform C# SqlServer 增删改查 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace SqlConnection1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } static string connstr = server=506-4\\SQL;database=Myform;user id=sa;pwd=123; SqlConnection sqlConn = new SqlConnection(connstr); private void Form1_Load(object sender, EventArgs e) { } public void clear() { txt_LoginId.Text = ; txt_LoginPwd.Text = ; txt_Nice.Text = ; txt_Name.Text = ; txt_Sex.Text = ; txt_Age.Text = ; } /// summary /// 添加数据 /// /summary /// param name=sender/param /// param name=e/param private void Butt_Add_Click(object sender, EventArgs e) { sqlConn.Open(); string sql = string.Format(insert into Users values({0},{1},{2},{3},{4},{5}), txt_LoginId.Text,txt_LoginPwd.Text, txt_Nice.Text, txt_Name.Text, txt_Sex.Text, txt_Age.Text); SqlCommand sqlcomm=new SqlCommand(sql,sqlConn); int result=0; try { result=sqlcomm.ExecuteNonQuery(); if(result==1) { MessageBox.Show(添加成功); clear(); } else { MessageBox.Show(添加失败); } } catch { MessageBox.Show(添加失败); } sqlConn.Close(); } /// summary /// 删除数据 /// /summary /// param name=sender/param /// param name=e/param private void Butt_Delete_Click(object sender, EventArgs e) {