小弟是.net新手,请教vs生成的代码怎么显示datagrid?
我是新手,现在用vs.net2003做的一页测试页面,功能很简单,就想连上数据库后把数据提取出来在datagrid中显示出来,在vs中调试都一切正常了,但在ie中就是看不到数据库中的数据,显示页面中还有一个DropDownList,也是绑定完数据显示不了,所以请大家帮帮忙看看源代码,是怎么回事?
显示页面:srz.aspx
---------------------------------------------------------------------
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="srz.aspx.vb" Inherits="WebApplication1.srz"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>srz</title>
<meta content="Microsoft Visual Studio .NET 7.0" name="GENERATOR">
<meta content="Visual Basic 7.0" name="CODE_LANGUAGE">
<meta content="VBScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:datagrid id=DataGrid1 style="Z-INDEX: 101; LEFT: 64px; POSITION: absolute; TOP: 45px" runat="server" DataSource="<%# My_DataSet1 %>" DataKeyField="user_id" DataMember="f_board">
<Columns>
<asp:ButtonColumn Text="选择" CommandName="Select"></asp:ButtonColumn>
<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="更新" CancelText="取消" EditText="编辑"></asp:EditCommandColumn>
<asp:ButtonColumn Text="删除" CommandName="Delete"></asp:ButtonColumn>
</Columns>
</asp:datagrid>
<asp:DropDownList id=DropDownList1 style="Z-INDEX: 102; LEFT: 320px; POSITION: absolute; TOP: 418px" runat="server" DataSource='<%# DataBinder.Eval(My_DataSet1, "Tables[f_board].DefaultView.[0].id", "{0}") %>' >
</asp:DropDownList></form>
</body>
</HTML>
---------------------------------------------------------------------
第二个文件srz.aspx.vb
---------------------------------------------------------------------
Public Class srz
Inherits System.Web.UI.Page
Protected WithEvents MyConnection As System.Data.OleDb.OleDbConnection
Protected WithEvents myOleDbDataAdapter As System.Data.OleDb.OleDbDataAdapter
Protected WithEvents my_OleDbSelectCommand As System.Data.OleDb.OleDbCommand
Protected WithEvents DropDownList1 As System.Web.UI.WebControls.DropDownList
Protected WithEvents My_DataSet1 As WebApplication1.my_DataSet
Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid
#Region " Web 窗体设计器生成的代码 "
'该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
Me.MyConnection = New System.Data.OleDb.OleDbConnection()
Me.myOleDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter()
Me.my_OleDbSelectCommand = New System.Data.OleDb.OleDbCommand()
Me.My_DataSet1 = New WebApplication1.my_DataSet()
CType(Me.My_DataSet1, System.ComponentModel.ISupportInitialize).BeginInit()
'
'MyConnection
'
Me.MyConnection.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Cata" & _
"log=temp_web;Data Source=SRZ-BIRD;Use Procedure for Prepare=1;Auto Translate=Tru" & _
"e;Packet Size=4096;Workstation ID=SRZ-BIRD;Use Encryption for Data=False;Tag wit" & _
"h column collation when possible=False"
'
'myOleDbDataAdapter
'
Me.myOleDbDataAdapter.SelectCommand = Me.my_OleDbSelectCommand
Me.myOleDbDataAdapter.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "f_board", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("id", "id"), New System.Data.Common.DataColumnMapping("related_id", "related_id"), New System.Data.Common.DataColumnMapping("re_id", "re_id"), New System.Data.Common.DataColumnMapping("_top", "_top"), New System.Data.Common.DataColumnMapping("quintessence", "quintessence"), New System.Data.Common.DataColumnMapping("lock", "lock"), New System.Data.Common.DataColumnMapping("user_id", "user_id"), New System.Data.Common.DataColumnMapping("face", "face"), New System.Data.Common.DataColumnMapping("enclosure", "enclosure"), New System.Data.Common.DataColumnMapping("_date", "_date"), New System.Data.Common.DataColumnMapping("total_mark", "total_mark"), New System.Data.Common.DataColumnMapping("title", "title"), New System.Data.Common.DataColumnMapping("text", "text")})})
'
'my_OleDbSelectCommand
'
Me.my_OleDbSelectCommand.CommandText = "SELECT id, related_id, re_id, _top, quintessence, lock, user_id, face, enclosure," & _
" _date, total_mark, title, text FROM f_board"
Me.my_OleDbSelectCommand.Connection = Me.MyConnection
'
'My_DataSet1
'
Me.My_DataSet1.DataSetName = "my_DataSet"
Me.My_DataSet1.Locale = New System.Globalization.CultureInfo("zh-CN")
Me.My_DataSet1.Namespace = "http://www.tempuri.org/my_DataSet.xsd"
CType(Me.My_DataSet1, System.ComponentModel.ISupportInitialize).EndInit()
End Sub
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
'不要使用代码编辑器修改它。
InitializeComponent()
End Sub
#End Region
Private Sub OleDbConnection1_InfoMessage(ByVal sender As System.Object, ByVal e As System.Data.OleDb.OleDbInfoMessageEventArgs) Handles MyConnection.InfoMessage
End Sub
End Class
---------------------------------------------------------------------