asp.net 3层结构访问数据库

第一层：default.aspx

public partial class _Default : System.Web.UI.Page
{
    //private const string PARM_A2 = "@a2";
    //private const string SQL_INSERT_A2 = "insert into a (a2) values (@a2)";

    protected void Page_Load(object sender, EventArgs e)
    {
       
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        string tx = TextBox1.Text;

        insert.insertsort(tx, "123");     

    }

 

    protected void Button2_Click(object sender, EventArgs e)
    {
        DataTable mytable = new DataTable();

        mytable = select.selectsort();

        GridView2.DataSource = mytable;
        GridView2.DataBind();

        Response.Write("2323");

    }
}
 

第2层： xxxx.cs

 public static DataTable selectsort()
    {
        SqlConnection conn = new SqlConnection();
        SqlCommand cmd = new SqlCommand();
        DataTable table = new DataTable();

        conn.ConnectionString = ConfigurationManager.ConnectionStrings["ACDataConnectionString"].ConnectionString;

        cmd.CommandType = CommandType.Text;
        cmd.CommandText = "select * from a";
        cmd.Connection = conn;

        SqlDataAdapter apt = new SqlDataAdapter();

        apt.SelectCommand = cmd;

        apt.Fill(table);

        return table;
    }

  public static void insertsort(string tx,string id)
    {
        SqlConnection conn = new SqlConnection();

        SqlCommand cmd = new SqlCommand();

        DataTable datatable = new DataTable();

        SqlDataReader datareader;

        conn.ConnectionString = ConfigurationManager.ConnectionStrings["ACDataConnectionString"].ConnectionString;

        cmd.CommandType = CommandType.Text;
        cmd.CommandText = "insert into a (a2,a3) values (@a2,@a3)";
        cmd.Connection = conn;

        SqlParameter parm1 = new SqlParameter("@a2", SqlDbType.Text);
        SqlParameter parm2 = new SqlParameter("@a3", SqlDbType.Text);
        parm1.Value = tx;
        parm2.Value = "123";
        cmd.Parameters.Add(parm1);
        cmd.Parameters.Add(parm2);
        cmd.Connection.Open();

        cmd.ExecuteNonQuery();

        cmd.Dispose();
        conn.Dispose(); 

    }

第3层数据库。。

这样的结构 访问数据库比较好