数据库链接

Imports System.IO
Module 数据库链接
   ACCESS ： provider=microsoft.jet.oledb.4.0;data source=|DataDirectory|\gongzi.mdb;Persist Security Info=True

SQL SERVER：Data Source=127.0.0.1;database=lyb;User ID=xyz91;pwd=

类：

public class sqldata
{
    private SqlConnection sqlcon;
    private SqlCommand sqlcom;
    private SqlDataAdapter sqldap;
 public sqldata()
 {
    try
        {
            sqlcon = new SqlConnection(ConfigurationManager.AppSettings["constr"]);
            sqlcon.Open();
        }
        catch
        {        }    }
        public bool ExecSql(string sqlcomstr)
        {
            try
            {
                sqlcom=new SqlCommand(sqlcomstr,sqlcon);
                sqlcom.ExecuteNonQuery();
                return true;
            }
            catch
            {
            return false;
            }
            finally
            {
            sqlcon.Close();
            }
        }
        public DataSet ExecDs(string sqlcomstr)
        {
            try
            {
                sqldap = new SqlDataAdapter(sqlcomstr, sqlcon);
                DataSet ds = new DataSet();
                sqldap.Fill(ds);
                return ds;
            }
            finally
            {
                sqlcon.Close();
            }
        }
   
        public SqlDataReader ExceRead(string sqlcomstr)
        {
            try
            {
                sqlcom=new SqlCommand(sqlcomstr,sqlcon);
                SqlDataReader read=sqlcom.ExecuteReader();
                return read;
            }
            finally
            {

            }

        }

 }

 

类的使用：
 protected void Button1_Click(object sender, EventArgs e)
    {
        sqldata li = new sqldata();
        string sqlcomstr = "insert into liao (name,password) values ('" + TextBox1.Text + "','" + TextBox2.Text + "' )";
        if (li.exsql(sqlcomstr))
        {
            Response.Write("输入成功！");
        }
        else
            Response.Write("输入失败！");
    }