Ado|datagrid <!--<%@ Page trace= "True"%>-->
<%@ Import namespace= "System.Data"%>
<%@ Import namespace= "System.Data.SqlClient"%>
<Html>
<body bgcolor= "White" >
<H3> using ado+, combining DataGrid-ado+.aspx <HR></H3>
<asp:datagrid headerstyle-backcolor= "Cyan" id= "GRID1" runat= "Server"/>
</Body>
</Html>
<script language= "VB" runat= "Server" >
Sub Page_Load (SRC as Object, e as EventArgs)
Grid1.datasource = Createdataview ("pubs", "Authors")
Grid1.databind ()
End Sub
Function Createdataview (Db As String, Table as String) as DataView
Dim connstr, SQL as String
ConnStr = "server=hnby-dom;uid=sa;pwd=;d atabase=" &db
Dim Conn as SqlConnection
Dim Cmd as SqlDataAdapter
Conn = new SqlConnection (CONNSTR)
CMD = New SqlDataAdapter ("select * from" & Table, ConnStr)
Dim ds As DataSet = new DataSet ()
Cmd.fill (ds, Table)
Createdataview = new DataView (ds. Tables (Table))
End Function
</script>
and using ado+ (i), here is a function createdataview, you can do this function in a single inclusion page.
------------------------------------------------
The above test passes in the Win2000server,win2000professional,sql6.0,microsoft. NET Framework SDK Beta2.
Example: http://202.102.247.235/aspx/ado2.aspx
