ASP如何连接到数据库?
给你个例子看看·如果你只是显示用DataReader,如果你要操作数据用DataSet。 <%@ Import namespace="System。Data" %> <%@ Import namespace="System。 Data。SqlClient" %> <html> <head> <title>Filling the DataSet and binding to the DataGrid</...全部
给你个例子看看·如果你只是显示用DataReader,如果你要操作数据用DataSet。 <%@ Import namespace="System。Data" %> <%@ Import namespace="System。
Data。SqlClient" %> <html> <head> <title>Filling the DataSet and binding to the DataGrid</title> </head> <body> < id="dgCategories" runat="server" /><br/> </body> </html> <script language="VB" runat="server"> Sub Page_Load(Source As Object, E As EventArgs) ' Connection setup Dim strConnection As String = "write down your connection string!!!" Dim objConnection As New SqlConnection(strConnection) Dim strSQL As String = "SELECT * FROM Categories" ' DataAdapter setup Dim objAdapter as New SqlDataAdapter(strSQL, objConnection) ' DataSet & Adapter & Table Dim objDataSet As New DataSet() objAdapter。
Fill(objDataSet, "dtCategories") dgCategories。DataSource = objDataSet。Tables("dtCategories") dgCategories。
DataBind() End Sub </script>。收起