查询数据库(SQL Server 2000)
string strSql="select users,password from user_info order by id desc";
SqlConnection con=new SqlConnection("Server=localhost;DataBase=Test;user id=sa;password=123456");
con.Open();
SqlCommand myCommand=new SqlCommand(strSql,con);
SqlDataReader myReader=myCommand.ExecuteReader();
DataGrid1.DataSource=myReader;
DataGrid1.DataBind();
********************************************
新增数据
SqlConnection con=new SqlConnection("Server=localhost;DataBase=Test;user id=sa;password=123456");
con.Open();
strSql="insert into user_info(users,password) values('"+TextBox1.Text.Trim()+"','"+TextBox2.Text.Trim()+"')";
SqlCommand myCommand=new SqlCommand(strSql,con);
myCommand.ExecuteNonQuery();
**************************************************
修改数据
SqlConnection con=new SqlConnection("Server=localhost;DataBase=Test;user id=sa;password=123456");
con.Open();
strSql="update user_info set users='"+TextBox3.Text.Trim()+"',password='"+TextBox4.Text.Trim()+"' where users='"+TextBox1.Text.Trim()+"' and password='"+TextBox2.Text.Trim()+"'";
SqlCommand myCommand=new SqlCommand(strSql,con);
myCommand.ExecuteNonQuery();
**********************************************
删除数据
string strSql="delete from user_info where users='"+TextBox1.Text.Trim()+"'";
SqlConnection con=new SqlConnection("Server=localhost;DataBase=Test;user id=sa;password=123456");
con.Open();
SqlCommand myCommand=new SqlCommand(strSql,con);
myCommand.ExecuteNonQuery();