seehttp://samples.gotdotnet.com/quickstart/aspplus/doc/webdataaccess.aspx
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %><html>
<script language="VB" runat="server"> Sub Page_Load(Sender As Object, E As EventArgs) Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter MyConnection = New SqlConnection("server=(local);database=pubs;uid=sa;pwd=;")
MyCommand = New SqlDataAdapter("select * from Authors", MyConnection) DS = new DataSet()
MyCommand.Fill(ds, "Authors") MyDataGrid.DataSource=ds.Tables("Authors").DefaultView
MyDataGrid.DataBind()
End Sub</script><body> <h3><font face="Verdana">Simple Select to a DataGrid Control</font></h3> <ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/></body>
</html>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %><html>
<script language="VB" runat="server"> Sub Page_Load(Sender As Object, E As EventArgs) Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter MyConnection = New SqlConnection("server=(local);database=pubs;uid=sa;pwd=;")
MyCommand = New SqlDataAdapter("select * from Authors", MyConnection) DS = new DataSet()
MyCommand.Fill(ds, "Authors") MyDataGrid.DataSource=ds.Tables("Authors").DefaultView
MyDataGrid.DataBind()
End Sub</script><body> <h3><font face="Verdana">Simple Select to a DataGrid Control</font></h3> <ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/></body>
</html>
解决方案 »
- UpdatePanel Repeater HyperLink分页 怎么局部刷新???
- 请教一个关于页面显示的问题
- 请教magicAJAX读取DataTable 数据的问题
- 菜鸟问曰:Response.Cookies和HttpCookie 有区别吗?
- 能否将浏览器的地址栏让用户看不见??
- 用什么类什么方法能获取当前的域名地址???????????????????????????
- 如何取datagrid中一行的值,并把它传给另一个页面?急!
- ASP.net编译出错,CS0006未找到元数据文件System.dll
- 急问:刚装了window server 2003,不是说asp.net网站在这IIS里可以游览吗?(2003不是不需要装.net框架吗?),可我这里游览不了为什么?
- Cookie 问题高手请进!!!急
- 大家谈谈自己对asp.net web matrix开发工具的体会
- .NET 环境下怎样生成统计图形
page_load()里主要做的就是
1.连接数据库;
Dim MyConnection As SqlConnectionMyConnection = New SqlConnection("server=(local);database=pubs;uid=sa;pwd=;")
2.定义Adapter;
3.填充DataSet;
4.绑定DataGrid;
其它同上!