[求助]大家请协助解答一下.ＮＥＴ的数据连接问题-->bygg转移 - VB.NET论坛

问题点数：0 回复次数：1

[求助]大家请协助解答一下.ＮＥＴ的数据连接问题-->bygg转移

我的程序语言是用ＶＢ，我这段代码写好后，运行起来没有提示错误，可是我的ＤＡＴＡＧＲＩＤ控件却没有任何内容
请高手帮我看看

＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="second.aspx.vb" Inherits="second" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>试验</title>
<style type="text/css">

</style>
<script language="vb" runat="server">
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
Sub page_load(ByVal Sender As Object, ByVal E As EventArgs)
If (Page.IsValid) Then
MyConnection = New SqlConnection("server=(local); database=pubs; uid=sa; pwd=sa; Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select * from titlesl where where price <> 0", MyConnection)
DS = New DataSet()
MyCommand.Fill(DS, "Titles")
dategrid1.DataSource = DS.Tables("Titles").DefaultView
dategrid1.DataBind()

End If
MyConnection.Close()
End Sub

</script>
</head>
<body>
<form id="form1" runat="server">
<asp:DataGrid ID="dategrid1" runat="server"></asp:DataGrid>
</form>
</body>
</html>

＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

谢谢了，请指教

搜索更多相关主题的帖子: bygg　ＮＥＴ　数据　协助　解答　