Populating a DataGrid

Hi all. I hope this is the right group
I am trying to populate a datagrid on an ASP.NET page from a MySQL table
using the .NET connector (ByteFX). But for the life of me, I just cannot
work it out. Can someone tell me what I am doing wrong? What I want is to
click a button and the contents of the table from the DB appears in the
DataGrid on my ASP page.
I tried to follow an example on the web and I just got lost. I have posted
my code below.
Dim ConnStr As String
ConnStr = "server=localhost; user
id=test;password=password;database=docum
ents;pooling=false"
Try
Dim TextConn As New MySqlConnection(ConnStr)
Dim TableAdaptor As New MySqlDataAdapter
'Dim CommBuild As New MySqlCommandBuilder
Dim TextDataTable As New DataTable
TextConn.Open()
TableAdaptor = New MySqlDataAdapter("SELECT * FROM daniel",
TextConn)
'CommBuild = New MySqlCommandBuilder(TableAdaptor)
TableAdaptor.Fill(TextDataTable)
TextGrid.DataSource = TextDataTable
IDBox.Text = TextGrid.Items.Count
'TitleBox.Text = TextDataTable.Columns.Count
BodyBox.Text = "Success"
Catch ex As Exception
BodyBox.Text = ex.Message
End Try
Thanks.
Bob
---
I'll have a B please Bob.What is the error you are getting?
"Bob Hollness" <bob@.blockbuster.com> wrote in message
news:ewNHEyM%23EHA.220@.TK2MSFTNGP09.phx.gbl...
> Hi all. I hope this is the right group
> I am trying to populate a datagrid on an ASP.NET page from a MySQL table
> using the .NET connector (ByteFX). But for the life of me, I just cannot
> work it out. Can someone tell me what I am doing wrong? What I want is
> to click a button and the contents of the table from the DB appears in the
> DataGrid on my ASP page.
> I tried to follow an example on the web and I just got lost. I have
> posted my code below.
> Dim ConnStr As String
> ConnStr = "server=localhost; user
> id=test;password=password;database=docum
ents;pooling=false"
> Try
> Dim TextConn As New MySqlConnection(ConnStr)
> Dim TableAdaptor As New MySqlDataAdapter
> 'Dim CommBuild As New MySqlCommandBuilder
> Dim TextDataTable As New DataTable
> TextConn.Open()
> TableAdaptor = New MySqlDataAdapter("SELECT * FROM daniel",
> TextConn)
> 'CommBuild = New MySqlCommandBuilder(TableAdaptor)
> TableAdaptor.Fill(TextDataTable)
> TextGrid.DataSource = TextDataTable
> IDBox.Text = TextGrid.Items.Count
> 'TitleBox.Text = TextDataTable.Columns.Count
> BodyBox.Text = "Success"
> Catch ex As Exception
> BodyBox.Text = ex.Message
> End Try
>
> Thanks.
> --
> Bob
> ---
> I'll have a B please Bob.
>
Hi Bob
try this
say that the table on the db is t1
dim con as new sqlconnection(constr)
dim adapter as new sqladapter("select * from t1",con)
dim ds as new dataset()
adapter.fill(ds,"mytable")
yourGrid.datasource(ds)
yourgrid.datamember("mytable")
yourgrid.databind()
this will work
do not open connection with dataadpter
"Bob Hollness" wrote:

> Hi all. I hope this is the right group
> I am trying to populate a datagrid on an ASP.NET page from a MySQL table
> using the .NET connector (ByteFX). But for the life of me, I just cannot
> work it out. Can someone tell me what I am doing wrong? What I want is t
o
> click a button and the contents of the table from the DB appears in the
> DataGrid on my ASP page.
> I tried to follow an example on the web and I just got lost. I have poste
d
> my code below.
> Dim ConnStr As String
> ConnStr = "server=localhost; user
> id=test;password=password;database=docum
ents;pooling=false"
> Try
> Dim TextConn As New MySqlConnection(ConnStr)
> Dim TableAdaptor As New MySqlDataAdapter
> 'Dim CommBuild As New MySqlCommandBuilder
> Dim TextDataTable As New DataTable
> TextConn.Open()
> TableAdaptor = New MySqlDataAdapter("SELECT * FROM daniel",
> TextConn)
> 'CommBuild = New MySqlCommandBuilder(TableAdaptor)
> TableAdaptor.Fill(TextDataTable)
> TextGrid.DataSource = TextDataTable
> IDBox.Text = TextGrid.Items.Count
> 'TitleBox.Text = TextDataTable.Columns.Count
> BodyBox.Text = "Success"
> Catch ex As Exception
> BodyBox.Text = ex.Message
> End Try
>
> Thanks.
> --
> Bob
> ---
> I'll have a B please Bob.
>
>
Don't worry, I solved it.
I changed "TextGrid.DataSource = TextDataTable" to "TextGrid.DataSource =
TextDataTable.DefaultView"
Bob
---
I'll have a B please Bob.
"Bob Hollness" <bob@.blockbuster.com> wrote in message
news:ewNHEyM%23EHA.220@.TK2MSFTNGP09.phx.gbl...
> Hi all. I hope this is the right group
> I am trying to populate a datagrid on an ASP.NET page from a MySQL table
> using the .NET connector (ByteFX). But for the life of me, I just cannot
> work it out. Can someone tell me what I am doing wrong? What I want is
> to click a button and the contents of the table from the DB appears in the
> DataGrid on my ASP page.
> I tried to follow an example on the web and I just got lost. I have
> posted my code below.
> Dim ConnStr As String
> ConnStr = "server=localhost; user
> id=test;password=password;database=docum
ents;pooling=false"
> Try
> Dim TextConn As New MySqlConnection(ConnStr)
> Dim TableAdaptor As New MySqlDataAdapter
> 'Dim CommBuild As New MySqlCommandBuilder
> Dim TextDataTable As New DataTable
> TextConn.Open()
> TableAdaptor = New MySqlDataAdapter("SELECT * FROM daniel",
> TextConn)
> 'CommBuild = New MySqlCommandBuilder(TableAdaptor)
> TableAdaptor.Fill(TextDataTable)
> TextGrid.DataSource = TextDataTable
> IDBox.Text = TextGrid.Items.Count
> 'TitleBox.Text = TextDataTable.Columns.Count
> BodyBox.Text = "Success"
> Catch ex As Exception
> BodyBox.Text = ex.Message
> End Try
>
> Thanks.
> --
> Bob
> ---
> I'll have a B please Bob.
>