c#与sqlserver数据库操作_附实例说明

《c#与sqlserver数据库操作_附实例说明》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、成功信息网www.020chenggong.comC#数据库连接操作大全下面是c#与数据库的连接及增删改除的各种操作，全部经过上机验证。本人是从事软件开发，如果各位有什么问题或者需要帮助的可以在我的空间留言。一：数据库连接代码：SqlConnectionobjSqlConnection=newSqlConnection("server=127.0.0.1;uid=sa;pwd=;database=test");objSqlConnection.Open();二：数据库的添加记录代码：            inti=0;    

2、      strings1="",s2="";          i=Convert.ToInt16(textBox1.Text);              s1=textBox2.Text;          s2=textBox3.Text;            SqlConnectionobjSqlConnection=newSqlConnection("server=127.0.0.1;uid=sa;pwd=;database=test");            objSqlConnection.Open(); 

3、                       MessageBox.Show("数据库连接成功","好");              try              {                  SqlCommandsqlcom=newSqlCommand("insertintoinfo(id,name,sex)values("+i+",'"+s1+"','"+s2+"')",objSqlConnection);                  sqlcom.ExecuteNonQuery();          

4、        MessageBox.Show("添加成功！","啊");              }              catch(Exceptiona)              {                  MessageBox.Show(a.ToString());              }            MessageBox.Show("添加成功！","啊");}三：数据库的修改代码：            inti=0;            strings1="",s2="";    

5、        s1=textBox2.Text;            s2=textBox3.Text;            if(textBox1.Text.Length==0)                i=0;            else                i=Convert.ToInt32(textBox1.Text);成功信息网www.020chenggong.com            SqlConnectionobjSqlConnection=newSqlConnection("serv

6、er=127.0.0.1;uid=sa;pwd=;database=test");            objSqlConnection.Open();            MessageBox.Show("数据库连接成功","好");            try            {                SqlCommandsqlcom=newSqlCommand("updateinfosetname='"+s1+"',sex='"+s2+"'"+"whereid="+i,objSqlConnection)

7、;                sqlcom.ExecuteNonQuery();                MessageBox.Show("修改成功！","啊");                objSqlConnection.Close();            }            catch(Exceptiona)            {                MessageBox.Show(a.ToString());            }四：数据库的删除代码：            in

8、ti=0;            strings1="",s2="";            s1=textBox2.Text;            s2=textBox3.Text;            if(textBox1.Text.Length==0