SQL Server 2005学习心得.docVIP

SQL Server 2005学习心得(已变成DLL控件可直接调用) C#编程连接SQL Server 2005 数据库的代码： 答： SqlConnection myconnection = new SqlConnection(Integrated Security=SSPI;Initial Catalog= 数据库名 ;Data Source=服务器名;User ID=用户登录名;Password=密码;Connect Timeout=30); myconnection.Open(); //打开数据库 obj SqlConnection.Close();//关闭数据库 C#编程访问数据表中的数据： 答：string SQL = select EmpName From tb_EmpInfo; SqlCommand thisCommand = new SqlCommand(SQL,myconnection); SqlDataReader thisReader = thisCommand.ExecuteReader(); while (thisReader.Read())//读取数据关键代码 { MessageBox.Show(thisReader[EmpName].ToString());//输出数据 } C#编程访问查询数据表的数据 答 string SQL = select EmpName From tb_EmpInfo where EmpName=‘邵珠勇’; SqlCommand thisCommand = new SqlCommand(SQL,myconnection); SqlDataReader thisReader = thisCommand.ExecuteReader(); while (thisReader.Read())//读取数据关键代码 { MessageBox.Show(thisReader[EmpName].ToString());//输出数据 } C#编程访问并往数据表中插入数据 string SQL = insert into tb_EmpInfo(EmpId,EmpName,EmpLoginName,EmpLoginPwd,EmpSex,EmpBirthDay,EmpDept,EmpPost,EmpPhone,EmpPhoneM,EmpAddress,EmpFalg) values束同同,zhanghan,123,男,1990/02/21,食品部,组长,1234567安徽省,0); SqlCommand thisCommand = new SqlCommand(SQL, myconnection); thisCommand.ExecuteNonQuery(); C#编程访问并更新数据表中的数据内容 答：string SQL = update tb_EmpInfo set EmpName= 束同,EmpSex=女 + where EmpID SqlCommand thisCommand = new SqlCommand(SQL, myconnection); thisCommand.ExecuteNonQuery(); C#编程访问并删除数据表中的数据内容 答： string SQL = delete from tb_EmpInfo where EmpID SqlCommand thisCommand = new SqlCommand(SQL, myconnection); thisCommand.ExecuteNonQuery(); C#中查询代码 答：string SQL = select EmpName From tb_EmpInfo; DataSet ds = new DataSet(); SqlDataAdapter obj=new SqlDataAdapter(); obj.SelectCommand = new SqlCommand(SQL,myconnection); obj.Fill(ds, tb_EmpInfo); dataGridView1.DataSource = ds.Tables[0];