中职数据库应用基础VisualFoxpro06 案例库 案例六 C#数据库连接操作.doc

《中职数据库应用基础VisualFoxpro06 案例库 案例六 C#数据库连接操作.doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

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.Tex

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

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

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

5、 i=0;            else                i=Convert.ToInt32(textBox1.Text);            SqlConnectionobjSqlConnection=newSqlConnection("server=127.0.0.1;uid=sa;pwd=;database=test");            objSqlConnection.Open();            MessageBox.Show("数据库连接成功","好");            try  

6、          {                SqlCommandsqlcom=newSqlCommand("updateinfosetname='"+s1+"',sex='"+s2+"'"+"whereid="+i,objSqlConnection);                sqlcom.ExecuteNonQuery();                MessageBox.Show("修改成功！","啊");                objSqlConnection.Close();            }

7、            catch(Exceptiona)            {                MessageBox.Show(a.ToString());            }四：数据库的删除代码：            inti=0;            strings1="",s2="";            s1=textBox2.Text;            s2=textBox3.Text;            if(textBox1.Text.Length==0)             

8、   i=0;            else                i=Convert.ToInt16(textBox1.Text);            SqlConnectionobjSql