C#数据库操作 附：代码实例说明

《C#数据库操作 附：代码实例说明》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、C#数据库连接操作大全一：数据库连接代码：SqlConnectionobjSqlConnection=newSqlConnection("server=127.0.0.1;uid=sa;pwd=;database=test");objSqlConnection.Open();二：数据库的添加记录代码：            inti=0;          strings1="",s2="";          i=Convert.ToInt16(textBox1.Text);              s1=textBox2.Text;          s2=textBox3.

2、Text;            SqlConnectionobjSqlConnection=newSqlConnection("server=127.0.0.1;uid=sa;pwd=;database=test");            objSqlConnection.Open();                        MessageBox.Show("数据库连接成功","好");              try              {                  SqlCommandsqlcom=newSqlCommand("insertintoi

3、nfo(id,name,sex)values("+i+",'"+s1+"','"+s2+"')",objSqlConnection);                  sqlcom.ExecuteNonQuery();                  MessageBox.Show("添加成功！","啊");              }              catch(Exceptiona)              {                  MessageBox.Show(a.ToString());              }            M

4、essageBox.Show("添加成功！","啊");}三：数据库的修改代码：            inti=0;            strings1="",s2="";            s1=textBox2.Text;            s2=textBox3.Text;            if(textBox1.Text.Length==0)                i=0;            else                i=Convert.ToInt32(textBox1.Text);            SqlConnecti

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

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

7、    strings1="",s2="";            s1=textBox2.Text;            s2=textBox3.Text;            if(textBox1.Text.Length==0)                i=0;            else                i=Convert.ToInt16(textBox1.Text);            SqlConnectionobjSqlC