增删查改连接sql语法
///sql连接
SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();
scsb.DataSource = "127.0.0.1";
scsb.UserID = "sa";
scsb.Password = "yzt686898";
scsb.InitialCatalog = "MySchool";
SqlConnection conn = new SqlConnection(scsb.Tostring()); //参数:连接数据库的字符串
if (conn.State == System.Data.ConnectionState.Closed) //判断连接开启状态 如果是关闭的
{
conn.Open(); //打开连接
}
string strSQL = "SELECT user_pwd FROM userinfo WHERE [user_id]='" + user_id + "'AND user_pwd = '" + user_pwd+"'";
//验证登录
sql验证user表里面的id及密码 实现返回连接
string conStr = "Data Source=.;Initial Catalog=MySchool;User ID=sa;Password=yzt686898";
SqlConnection conn = new SqlConnec