C#与sqlserver数据库操作-附实例说明(共5页)

1、精选优质文档-倾情为你奉上C#数据库连接操作大全下面是c#与数据库的连接及增删改除的各种操作，全部经过上机验证。本人是从事软件开发，如果各位有什么问题或者需要帮助的可以在我的空间留言。一：数据库连接代码：SqlConnection objSqlConnection = new SqlConnection ("server = ;uid = sa; pwd =;database =test");objSqlConnection.Open();二：数据库的添加记录代码：       

2、0;    int i = 0;          string s1 = "", s2 = ""          i = Convert.ToInt16(textBox1.Text);           

3、   s1 = textBox2.Text;          s2 = textBox3.Text;            SqlConnection objSqlConnection = new SqlConnection("server = ;uid = sa; pwd =;database =test"

4、);            objSqlConnection.Open();                        MessageBox.Show("数据库连接成功", "好"); 

5、              try                                 SqlCommand sqlcom = new S

6、qlCommand("insert into info(id,name,sex) values( " + i + ",'" + s1 + "','" + s2 + "')", objSqlConnection);                  sqlcom.ExecuteNonQuery(); 

7、;                  MessageBox.Show("添加成功！", "啊");                         &

8、#160;   catch (Exception a)                                  MessageBox.Show(a.ToString();      

9、;                     MessageBox.Show("添加成功！", "啊");三：数据库的修改代码：            int i = 0;      

10、;      string s1 = "", s2 = ""            s1 = textBox2.Text;            s2 = textBox3.Text;      &#

11、160;     if (textBox1.Text.Length = 0)                i = 0;            else          

12、;      i = Convert.ToInt32(textBox1.Text);            SqlConnection objSqlConnection = new SqlConnection("server = ;uid = sa; pwd =;database =test");       

13、     objSqlConnection.Open();            MessageBox.Show("数据库连接成功", "好");            try        

14、;                    SqlCommand sqlcom = new SqlCommand("update info set name='"+s1+"',sex='"+s2+"'"+"where id=" + i, objSqlConnection); &#

15、160;              sqlcom.ExecuteNonQuery();                MessageBox.Show("修改成功！", "啊");       

16、;         objSqlConnection.Close();                        catch (Exception a)         

17、60;                  MessageBox.Show(a.ToString();            四：数据库的删除代码：            int i

18、 = 0;            string s1 = "", s2 = ""            s1 = textBox2.Text;            s2 = textBox3.Tex

19、t;            if(textBox1.Text.Length=0)                i=0;            else    

20、             i = Convert.ToInt16(textBox1.Text);            SqlConnection objSqlConnection = new SqlConnection("server = ;uid = sa; pwd =;database =test"); 

21、                       objSqlConnection.Open();            MessageBox.Show("数据库连接成功", "好");  &#

22、160;         try                            SqlCommand sqlcom = new SqlCommand("delete from info where id=&quo

23、t;+i, objSqlConnection);                sqlcom.ExecuteNonQuery();                MessageBox.Show("删除成功！", "啊"); 

24、60;              objSqlConnection.Close();                        catch (Exception a)    &

25、#160;                       MessageBox.Show(a.ToString();            五：数据库的查询代码：       

26、60;    1.类开始：                  DataTable dt1 = new DataTable();                  SqlDataAdapter da1

27、= new SqlDataAdapter();            2.按钮代码：            int i = 0,n=0;            string s1 = "", s2 = "&qu

28、ot;            s1 = textBox2.Text;            s2 = textBox3.Text;           if (textBox1.Text.Length = 0)    &

29、#160;           i = 0;            else                i = Convert.ToInt32(textBox1.Text);  

30、0;         SqlConnection objSqlConnection = new SqlConnection("server = ;uid = sa; pwd =;database =test");            objSqlConnection.Open();     

31、0;      MessageBox.Show("数据库连接成功", "好");            string query = "SELECT * from info where id="+i;            DataSet

32、objDataSet = new DataSet();            SqlDataAdapter obj = new SqlDataAdapter();                      obj.SelectCommand = new Sql

33、Command(query, objSqlConnection);            obj.Fill(objDataSet, "info");                    SqlCommand objSqlCommand = new SqlCo

34、mmand(query, objSqlConnection);            SqlDataReader objSqlReader = objSqlCommand.ExecuteReader();             while (objSqlReader.Read()      

35、60;                             n += 1;                   &#

36、160;MessageBox.Show("编号: " + objSqlReader.Getvalue(0) + "  姓名:" + objSqlReader.Getvalue(1) + "  性别" + objSqlReader.Getvalue(2);                    

37、60;           if (n = 0)                    MessageBox.Show("数据库中没有这样的记录！");六：数据库的查询代码：       int i = 0;&

38、#160;          / int n = 0;            string s1 = "", s2 = ""            string sql;     

39、       s1 = textBox2.Text;            s2 = textBox3.Text;            if (textBox1.Text.Length = 0)        

40、;                    i = 0;                             

41、;           else                i = Convert.ToInt32(textBox1.Text);           SqlConnection objSqlConnection = new

42、SqlConnection("server = ;uid = sa; pwd =;database =test");                      objSqlConnection.Open();           &

43、#160;MessageBox.Show("数据库连接成功", "好");            string query = "SELECT * from info where id="+i;            if(i=0)     

44、0;            sql = "select * from info "            else                  sql =

45、 "select * from info where id=" + i;            da1 = new SqlDataAdapter(sql, objSqlConnection);            dt1.Clear();        &#

46、160;   da1.Fill(dt1);            dataGridView1.DataSource = dt1;数据库的封装类代码：class DBClass            public void dbclass(string  sql)    

47、                try                            SqlConnection sqlcon = new SqlCon

48、nection("server = ;uid = sa; pwd =;database =test");                sqlcon.Open();                    

49、;        SqlTransaction objt = sqlcon.BeginTransaction();  /事物开始                              SqlCom

50、mand sqlcom = new SqlCommand(sql, sqlcon);                                sqlcom.Transaction = objt; /将Command 对象设置为事物处理的对象   

51、;                         sqlcom.ExecuteNonQuery();                objt.Commit();         /提交事物                sqlcon.Close();                      &#