初学者学习《ASP.net2.0高级编程》时，调不出的一个例子，求救
日期：2014-05-19 浏览次数：20499 次
菜鸟学习《ASP.net2.0高级编程》时，调不出的一个例子，求救！
第十二章 使用ADO.net管理数据，程序清单12-1，想问的是：
1、自己觉得可能是ConfigurationManager.ConnectionStrings( "DSN_Northwind ").ConnectionString地方有问题，但不知如何修改；
2、如果想引用web.config中定义的数据连接字符串，应该如何修改？
源码如下：
<%@ Page Language= "VB "%>
<%@ Import Namespace= "System.Data " %>
<%@ Import Namespace= "System.Data.SqlClient " %>
<%@ Import Namespace= "System.Configuration " %>
<script runat= "server ">
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
If Not Page.IsPostBack Then
Dim MyConnection As SqlConnection
Dim MyCommand As SqlCommand
Dim MyReader As SqlDataReader
MyConnection = New SqlConnection()
MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings( "DSN_Northwind ").ConnectionString
MyCommand = New SqlCommand()
MyCommand.CommandText = "SELECT TOP 3 * FROM CUSTOMERS "
MyCommand.CommandType = CommandType.Text
MyCommand.Connection = MyConnection
MyCommand.Connection.Open()
MyReader = MyCommand.ExecuteReader(CommandBehavior.CloseConnection)
gvCustomers.DataSource = MyReader
gvCustomers.DataBind()
MyCommand.Dispose()
MyConnection.Dispose()
End If
End Sub
</script>
<html>
<body>
<form id= "form1 " runat= "server ">
<div>
<asp:GridView ID= "gvCustomers " runat= "server ">
&n
第十二章 使用ADO.net管理数据，程序清单12-1，想问的是：
1、自己觉得可能是ConfigurationManager.ConnectionStrings( "DSN_Northwind ").ConnectionString地方有问题，但不知如何修改；
2、如果想引用web.config中定义的数据连接字符串，应该如何修改？
源码如下：
<%@ Page Language= "VB "%>
<%@ Import Namespace= "System.Data " %>
<%@ Import Namespace= "System.Data.SqlClient " %>
<%@ Import Namespace= "System.Configuration " %>
<script runat= "server ">
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
If Not Page.IsPostBack Then
Dim MyConnection As SqlConnection
Dim MyCommand As SqlCommand
Dim MyReader As SqlDataReader
MyConnection = New SqlConnection()
MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings( "DSN_Northwind ").ConnectionString
MyCommand = New SqlCommand()
MyCommand.CommandText = "SELECT TOP 3 * FROM CUSTOMERS "
MyCommand.CommandType = CommandType.Text
MyCommand.Connection = MyConnection
MyCommand.Connection.Open()
MyReader = MyCommand.ExecuteReader(CommandBehavior.CloseConnection)
gvCustomers.DataSource = MyReader
gvCustomers.DataBind()
MyCommand.Dispose()
MyConnection.Dispose()
End If
End Sub
</script>
<html>
<body>
<form id= "form1 " runat= "server ">
<div>
<asp:GridView ID= "gvCustomers " runat= "server ">
&n
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
