新手高分求一个SQL连接的范例

Question

sql数据库

Answer 1

如何执行一个sql语句： /// <summary>
    /// 执行一条sql语句
    /// </summary>
    /// <param name="sqlStr">sql语句</param>
    public static void ExecuteSql(string sqlStr)
    {
        try
        {
            openConnection();
            comm.CommandType = CommandType.Text;
            comm.CommandText = sqlStr;
            comm.ExecuteNonQuery();
        }
        catch (Exception e)
        {
            throw new Exception(e.Message);
        }
        finally
        {
            closeConnection();
        }
    }
调用方法执行插入语句：string sql = "insert into user(username,password) values('" textbox_username.text+ "','" + textbox_pwd.text+ "')";
        Common.ExecuteSql(sql);//这边看你方法写在哪里，自己修改一个页面你就去掉Common.
注意你的user表的ID要设为自动增长如何判断数据库有没有这个人 ，那你就查数据库有没有这个人  ，有就不插入没有就执行上面的语句

Answer 2

 /// <summary>
    /// 打开连接
    /// </summary>
    private static void openConnection()
    {
        if (conn.State == ConnectionState.Closed)
        {
            try
            {
                conn.ConnectionString =System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
                comm.Connection = conn;
                conn.Open();
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
        }
    }
    /// <summary>
    /// 关闭连接
    /// </summary>
    private static void closeConnection()
    {
        if (conn.State == ConnectionState.Open)
        {
            conn.Close();
        }
        conn.Dispose();
        comm.Dispose();
    }

Answer 3

在web.config中：
  <connectionStrings>
    <add name="sqlconn" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\工作区\C#项目\RMS\RMS\RMS\DB\RMSDB.mdf;Integrated Security=True;Connect Timeout=30" providerName="System.Data.SqlClient"/>
  </connectionStrings>在register.aspx.cs中：        protected void Button1_Click(object sender, EventArgs e)
        {
            string username = TextBox_username.Text;
            string pwd = TextBox_pwd.Text;
            string name = TextBox_name.Text;            DAL.adduser add = new DAL.adduser();
            if (add.addusers(username, pwd, name))
                MessageBox.Show("用户创建成功");
        }
在addusers。cs中：
namespace RMS.DAL
{
    public class adduser
    {
        public bool addusers(string username, string pwd, string name) 
        {
            SqlConnection coon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString);
            string strSql = "insert into Users(userName,userPwd,name) values('" + username + "','" + pwd + "','" + name+"')";
            coon.Open();
            SqlCommand comm = new SqlCommand(strSql, coon);
            if (comm.ExecuteNonQuery() > 0)
            {
                coon.Close();
                return true;
            }
            else
            {
                coon.Close();
                return false;
            }
        }
    }
}