110,534
社区成员
发帖
与我相关
我的任务
分享
public DataTable binddata()
{
DataTable tt = new DataTable();
SqlConnection con = new SqlConnection(sqlcon);
string sql = "SELECT * FROM test";
SqlDataAdapter adt = new SqlDataAdapter(sql, con);
adt.Fill(tt);
return tt;
}
protected void Page_Load(object sender, EventArgs e)
{
GridView1.DataSource = binddata();
GridView1.DataBind();
}
public DataSet binddata1()
{
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection(sqlcon);
string sql = "SELECT * FROM test";
SqlDataAdapter adt = new SqlDataAdapter(sql, con);
adt.Fill(ds);
return ds;
}
protected void Page_Load(object sender, EventArgs e)
{
GridView1.DataSource = binddata1();
GridView1.DataBind();
}
public SqlDataReader bind()
{
SqlConnection con = new SqlConnection(sqlcon);
string sql = "SELECT * FROM test";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return dr;
}
protected void Page_Load(object sender, EventArgs e)
{
GridView1.DataSource = bind();
GridView1.DataBind();
}
前台:aspx
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID">
<Columns>
<asp:BoundField DataField="Pid" HeaderText="Pid" SortExpression="Pid" />
<asp:BoundField DataField="Pname" HeaderText="Pname" SortExpression="Pname" />
<asp:BoundField DataField="Pmode" HeaderText="Pmode" SortExpression="Pmode" />
<asp:BoundField DataField="Ptime" HeaderText="Ptime" SortExpression="Ptime" />
</Columns>
</asp:GridView>
前端不懂,求教该怎么做,最好来个实例