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=textB

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

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

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

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

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

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