天天看点

c#数据库连接初级入门

   strconn 是连接数据库的连接字符串“Server=“要连接数据库所在机器的IP地址”;uid=sa;pwd=;database=数据库名称”

 sqlcomm.ExecuteNonQuery();是执行sqlcomm.CommandText = "delete from lgx1 where userID = '"+this.textBox1.Text.Trim()+"'";中的SQL语句

   string strconn = "Server=10.194.130.201;uid=sa;pwd=;database=lesson";

   SqlConnection conn = new SqlConnection();

   conn.ConnectionString = strconn;

   conn.Open();

   SqlCommand sqlcomm = conn.CreateCommand();

   sqlcomm.CommandText = "delete from TableName where userID = '"+this.textBox1.Text.Trim()+"'";

   sqlcomm.ExecuteNonQuery();

   conn.Close();