<% @ Import Namespace="System.Data" %>
<% @ import namespace="System.Data.SqlClient" %>
<script language="vb" runat="server">
sub page_load(sender as Object,e as EventArgs)
'数据库连接
dim MyConn as SqlConnection
dim MyCommd as SqlDataAdapter
dim Ds as DataSet
MyConn = new SqlConnection("server=Pc06;database=Hospital;uid=sa;pwd=;Trusted_Connection=yes" )
MyCommd = new SqlDataAdapter("Select yhdm from xt_user",MyConn)
ds = New dataSet()
MyCommd.Fill(DS, "xt_user")
YHGL.DataSource = DS.Tables("xt_user").DefaultView
YHGL.DataBind()
end sub
</script><asp:datagrid id="YHGL" runat="server" Width="100%" AutoGenerateColumns="False" CellPadding="0"> </asp:datagrid>
<% @ import namespace="System.Data.SqlClient" %>
<script language="vb" runat="server">
sub page_load(sender as Object,e as EventArgs)
'数据库连接
dim MyConn as SqlConnection
dim MyCommd as SqlDataAdapter
dim Ds as DataSet
MyConn = new SqlConnection("server=Pc06;database=Hospital;uid=sa;pwd=;Trusted_Connection=yes" )
MyCommd = new SqlDataAdapter("Select yhdm from xt_user",MyConn)
ds = New dataSet()
MyCommd.Fill(DS, "xt_user")
YHGL.DataSource = DS.Tables("xt_user").DefaultView
YHGL.DataBind()
end sub
</script><asp:datagrid id="YHGL" runat="server" Width="100%" AutoGenerateColumns="False" CellPadding="0"> </asp:datagrid>
解决方案 »
- 索引应该怎么加啊?谢谢了
- 我给高分!在后台创建的dropdownlist控件为什么无法默认选中一项?
- 看似简单的问题:MyClass myClass = new MyClass(); 如何让myClass.Name等于"myClass"?
- cs文件读 js中保存的cookie
- 自定义控件在设计时如何让他有背景图片
- asp.net中如何制作当用户注册完毕后,会有提示将在几秒中转到登录界面的这个效果??
- Repeater分页求助(输入字符串的格式不正确。)
- 关于HTML上的FILE控键后面按钮显示问题的问题
- 关于textarea的问题
- 有关DataGrid"按钮"列的Text, HeaderText根据记录名字发生改变的问题
- ===***=== 大家帮忙解决这个懒惰客户的需求 ==***====
- datagrid问题
{
//....................
}
{
//....................
}
If(!IsPostBack)
{}
1。if (not ispostBack) 不行2,AutoGenerateColumns ="true"
AutoGenerateColumns ="False"
也不行
server=Pc06;database=Hospital;uid=sa;pwd=;Trusted_Connection=yes
改为这个看看
server=localhost;database=Hospital;uid=sa;pwd=;Trusted_Connection=yes
Font-Size="9pt" Font-Names="宋体" AllowSorting="True">
<Columns>
<asp:TemplateColumn HeaderText="序号">
<ItemTemplate>
<asp:Label id=Label1 runat="server" Text='<%# Container.ItemIndex+1%>'>
</asp:Label>
</ItemTemplate>
<asp:TemplateColumn SortExpression="TransactDept" HeaderText="经办单位">
<ItemTemplate>
<asp:Label runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "TransactDept") %>' ID="Label5">
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
</asp:TemplateColumn>
</Columns>
<PagerStyle Visible="False" Position="Top" Mode="NumericPages"></PagerStyle>
</asp:datagrid>
=====>DS.Tables["xt_user"].