使用SqlDBHelper对数据库进行操作

SqlDBHelpe类的详情请看上一篇文章

定义一个show方法显示数据

public void show() 
    {
        SqlDataReader dr = DB.exeDataRedaer("select * from stu");
        while (dr.Read())
        {
            Response.Write(dr["SName"].ToString() + " " + dr["SSex"].ToString() + " " + dr["SAge"].ToString() + "<br/>");
        }
    }

1.把所有数据显示出来

       DataTable dt=SqlDbHelper.ExecuteDataTable("select * from stu");
       GridView1.DataSource = dt;
       GridView1.DataBind();

2.对数据库进行增删改操作

        SqlDbHelper.ExecuteNonQuery("sql语句") ;

3.使用模型类绑定数据到DropDownList中

       Stu stu;
       SqlConnection con = SqlDbHelper.getConnection();
       SqlDataReader dr=SqlDbHelper.ExecuteReader("select * from stu",con);
       List<Stu> SList = new List<Stu>();
       while (dr.Read())
       {
           stu = new Stu();
           stu.Sid = Convert.ToInt32(dr["Sid"].ToString());
           stu.Sname = dr["SName"].ToString();
           stu.Ssex = dr["SSex"].ToString();
           stu.Sage = Convert.ToInt32(dr["SAge"].ToString());
           stu.Img = dr["Img"].ToString();
           SList.Add(stu);
       }
       DropDownList1.DataSource = SList;
       DropDownList1.DataTextField = "SName";
       DropDownList1.DataValueField = "SName";
       DropDownList1.DataBind();    

4.执行存储过程

        SqlParameter sq=new SqlParameter("@SSex",SqlDbType.NVarChar,5);
        sq.Value="男";
        DataTable dt = SqlDbHelper.ExecuteDataTable(CommandType.StoredProcedure, "GetStusBySex", sq);
        GridView1.DataSource = dt;
        GridView1.DataBind();

存储过程GetStusBySex

CREATE PROCEDURE GetStusBySex
	@sex varchar
AS
BEGIN
	select * from stu where sex=@sex
END
GO