databinding system.data.datarowview不包括名为uid的属性,我的数据库的表里有这个字段,控件也加了对应的,代码如下,求大神解答SqlConnection conn=newSqlConnection(); conn.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\mydb.mdf;Integrated Security=True";
string SqlStr = "select uid as 学号,uname as 姓名,usex as 性别,math as 数学,chs as语文,en as英语 from grade"; SqlDataAdapter da = new SqlDataAdapter(SqlStr,conn); DataTable dt = new DataTable(); da.Fill(dt);
GridView1.Caption = "<b></h2>曙光学校学生成绩表</h2><b>"; GridView1.DataSourceID = null; GridView1.DataSource = dt; GridView1.DataBind()
控件代码如下
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="uid" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="uid" HeaderText="uid" ReadOnly="True" SortExpression="uid" /> <asp:BoundField DataField="uname" HeaderText="uname" SortExpression="uname" /> <asp:CheckBoxField DataField="usex" HeaderText="usex" SortExpression="usex" /> <asp:BoundField DataField="math" HeaderText="math" SortExpression="math" /> <asp:BoundField DataField="chs" HeaderText="chs" SortExpression="chs" /> <asp:BoundField DataField="en" HeaderText="en" SortExpression="en"/> </Columns> </asp:GridView > <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="uid" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="uid" HeaderText="uid" ReadOnly="True" SortExpression="uid" /> <asp:BoundField DataField="uname" HeaderText="uname" SortExpression="uname" /> <asp:CheckBoxField DataField="usex" HeaderText="usex" SortExpression="usex" /> <asp:BoundField DataField="math" HeaderText="math" SortExpression="math" /> <asp:BoundField DataField="chs" HeaderText="chs" SortExpression="chs" /> <asp:BoundField DataField="en" HeaderText="en" SortExpression="en"/> </Columns> </asp:GridView >
string SqlStr = "select uid as 学号,uname as 姓名,usex as 性别,math as 数学,chs as语文,en as英语 from grade"; SqlDataAdapter da = new SqlDataAdapter(SqlStr,conn); DataTable dt = new DataTable(); da.Fill(dt);
GridView1.Caption = "<b></h2>曙光学校学生成绩表</h2><b>"; GridView1.DataSourceID = null; GridView1.DataSource = dt; GridView1.DataBind()
控件代码如下
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="uid" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="uid" HeaderText="uid" ReadOnly="True" SortExpression="uid" /> <asp:BoundField DataField="uname" HeaderText="uname" SortExpression="uname" /> <asp:CheckBoxField DataField="usex" HeaderText="usex" SortExpression="usex" /> <asp:BoundField DataField="math" HeaderText="math" SortExpression="math" /> <asp:BoundField DataField="chs" HeaderText="chs" SortExpression="chs" /> <asp:BoundField DataField="en" HeaderText="en" SortExpression="en"/> </Columns> </asp:GridView > <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="uid" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="uid" HeaderText="uid" ReadOnly="True" SortExpression="uid" /> <asp:BoundField DataField="uname" HeaderText="uname" SortExpression="uname" /> <asp:CheckBoxField DataField="usex" HeaderText="usex" SortExpression="usex" /> <asp:BoundField DataField="math" HeaderText="math" SortExpression="math" /> <asp:BoundField DataField="chs" HeaderText="chs" SortExpression="chs" /> <asp:BoundField DataField="en" HeaderText="en" SortExpression="en"/> </Columns> </asp:GridView >
解决方案 »
- 怎么在网站首页 头部横幅 加个 水波纹闪动的效果
- asp.net dll 反编译后重新编译问题,高分请教
- |zyciis| 200分 要做一个统计网站各种访问量的就像 Google的Analytics平台 但现在问题是,用什么方法来取"网站平均停留时间""跳出率 "
- gridview可以如此编辑和删除吗?
- 很简单的问题,就我不会的!
- webpart的问题!!!
- 如何通过活动目录(AD)在域中修改和删除用户帐户
- IIS连接字符串问题《急!!!1》
- 有关网页过期的问题
- 我想下一个用asp.net做的bbs源码,请问哪位大哥哥知道呢
- 无法在web服务器上调试,这是咋了???
- ASP.NET:在浏览器中现实应用服务器错误。
你这里查出来之后就没得uid了,改成学号了, 就全是中文了 ,用中文绑
楼上正解