ado.net两种连接数据库的方式

protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack)//判断该页是否正为响应客户端回发而加载，或者它是否正被首次加载和访问
        {
            getValue();
        }
    }

 

第一种方式（连接模式）：

public void getValue()

{

        //不支持数据源分页

        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

        SqlCommand comm = new SqlCommand();

        comm.Connection = conn;

        comm.CommandType = CommandType.Text;

        comm.CommandText = "Select * from 表名";

        conn.Open();

 

        SqlDataReader reader = comm.ExecuteReader(CommandBehavior.CloseConnection);

        GridView1.DataSource = reader;//为GridView1指定数据源

        GridView1.DataBind();

        reader.Close();

        conn.Close();

 }

 

第二种方式（非连接模式）：

public void getValue()
    {

        //支持数据源分页
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

        SqlCommand comm = new SqlCommand();

        comm.Connection = conn;

        comm.CommandType = CommandType.Text;

        comm.CommandText = "Select * from 表名";

 

        SqlDataAdapter da = new SqlDataAdapter(comm);
        DataSet ds = new DataSet();

        //DataTable dt = new DataTable();

        da.Fill(ds);

        //da.Fill(dt);
        GridView1.DataSource = ds.Tables[0].DefaultView;

        //GridView1.DataSource = dt.DefaultView;
        GridView1.DataBind();

 

    }