代码如下
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class Default3 : System.Web.UI.Page
{
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{ }
protected void Page_Load(object sender, EventArgs e)
{
string ConnectionString = "server=(local);uid=sa;pwd=123456;DataBase=newsdb";
SqlConnection conn = new SqlConnection(ConnectionString); conn.Open(); string selectSQL = "select * from db_Admin"; SqlDataAdapter sda = new SqlDataAdapter(selectSQL, conn);
DataSet ds = new DataSet();
sda.Fill(ds, "table");
GridView1.DataSource = ds.Tables["table"];
conn.Close();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class Default3 : System.Web.UI.Page
{
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{ }
protected void Page_Load(object sender, EventArgs e)
{
string ConnectionString = "server=(local);uid=sa;pwd=123456;DataBase=newsdb";
SqlConnection conn = new SqlConnection(ConnectionString); conn.Open(); string selectSQL = "select * from db_Admin"; SqlDataAdapter sda = new SqlDataAdapter(selectSQL, conn);
DataSet ds = new DataSet();
sda.Fill(ds, "table");
GridView1.DataSource = ds.Tables["table"];
conn.Close();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
}
}
解决方案 »
- 这段话报错,输入字符串的格式不正确,formatexception,是为什么呢,请教高手
- <script type="text/javascript" src="CommentVote.aspx?modelID=111"></script>传值问题
- 一个很简单的,sql查询结果赋值的问题!
- 页面跳转问题
- 请问如何判断SqlCommand的ExecuteReader的值是否为空?
- ListBox问题
- ascx控件再次打开新的aspx页面后,新打开的aspx页面如何访问打开它的ascx控件中的某个label控件的值呢?
- !!超级菜鸟问题!! 怎么在DataGrid里捆绑2个表??
- 在线提问:字符串的分隔
- sql server中 或oracle中替换in和not的高效方法
- HTMLTextWriter先输出p元素再输出hr子元素出问题?求助
- 问个关于NPOI的小白问题
你看你datatable里面有没有数据呀
这句话有问题。
DataSet ds = new DataSet();
sda.Fill(ds, "table");
GridView1.DataSource = ds.Tables["table"];
GridView1.DataBind();
conn.Close();
正解,如果你GridView上还没数据,断点看看DataTable是否取到数据了。