Quote:
|
quote: I get an empty MXDataGridField collection.
|
Its should work fine
Try the code below
Code:
<%@ Page Language="VB" %>
<%@ Register TagPrefix="wmx" Namespace="Microsoft.Matrix.Framework.Web.UI" Assembly="Microsoft.Matrix.Framework, Version=0.6.0.0, Culture=neutral, PublicKeyToken=6f763c9966660626" %>
<script runat="server">
Function GetData() As System.Data.DataSet
Dim connectionString As String = "server='(local)'; trusted_connection=true; database='pubs'"
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Dim queryString As String = "SELECT [authors].[au_id], [authors].[au_lname], [authors].[au_fname], [authors].["& _
"phone], [authors].[address], [authors].[zip], [authors].[state], [authors].[city"& _
"] FROM [authors]"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.SqlClient.SqlDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)
Return dataSet
End Function' Insert page code here
'
Sub Page_Load(sender As Object, e As EventArgs)
MxDataGrid1.Datasource = GetData()
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<wmx:MxDataGrid id="MxDataGrid1" runat="server" AutoGenerateFields="False">
<Fields>
<wmx:BoundField DataField="au_id" HeaderText="au_id"></wmx:BoundField>
<wmx:BoundField DataField="au_lname" HeaderText="au_lname"></wmx:BoundField>
</Fields>
</wmx:MxDataGrid>
</form>
</body>
</html>
MxDataGrid Control
