Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)

[connection object creation]

Dim sSQL As String = "SELECT * FROM tPlayers"

Dim myAdapter As OleDbDataAdapter = New
OleDbDataAdapter(sSQL,myConnection)


Dim MyDataSet As New DataSet

myAdapter.Fill(MyDataSet)


GridView1.DataSource = MyDataSet

GridView1.DataBind()

myConnection.Close()

End Sub


I know the connection object is good because I use it else where, I have
edited out from the event above.

I have the require Namespaces , so it must be syntax, but I cannot for the
life of me see what the problem is.

Can anyone else?

GridView1.DataSource = MyDataSet.Tables[0];


A DataSet is a collection of DataTables.

You have to pick a Table.




"Paul W Smith" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Protected Sub Page_Load(ByVal sender As Object, ByVal e As
> System.EventArgs)
>
> [connection object creation]
>
> Dim sSQL As String = "SELECT * FROM tPlayers"
>
> Dim myAdapter As OleDbDataAdapter = New
> OleDbDataAdapter(sSQL,myConnection)
>
>
> Dim MyDataSet As New DataSet
>
> myAdapter.Fill(MyDataSet)
>
>
> GridView1.DataSource = MyDataSet
>
> GridView1.DataBind()
>
> myConnection.Close()
>
> End Sub
>
>
> I know the connection object is good because I use it else where, I have
> edited out from the event above.
>
> I have the require Namespaces , so it must be syntax, but I cannot for the
> life of me see what the problem is.
>
> Can anyone else?
>

Where is the command object.

"Paul W Smith" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Protected Sub Page_Load(ByVal sender As Object, ByVal e As
> System.EventArgs)
>
> [connection object creation]
>
> Dim sSQL As String = "SELECT * FROM tPlayers"
>
> Dim myAdapter As OleDbDataAdapter = New
> OleDbDataAdapter(sSQL,myConnection)
>
>
> Dim MyDataSet As New DataSet
>
> myAdapter.Fill(MyDataSet)
>
>
> GridView1.DataSource = MyDataSet
>
> GridView1.DataBind()
>
> myConnection.Close()
>
> End Sub
>
>
> I know the connection object is good because I use it else where, I have
> edited out from the event above.
>
> I have the require Namespaces , so it must be syntax, but I cannot for the
> life of me see what the problem is.
>
> Can anyone else?
>

Never mind command object,

Are you or are you not getting a Syntax error.
Syntax errors are generated by the complier before the runtime errors.

Can you findout what you get from MyDataSet.Tables.count?
or MyDataSet.Tables[0].Rows[0].count
etc...


"Paul W Smith" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Protected Sub Page_Load(ByVal sender As Object, ByVal e As
> System.EventArgs)
>
> [connection object creation]
>
> Dim sSQL As String = "SELECT * FROM tPlayers"
>
> Dim myAdapter As OleDbDataAdapter = New
> OleDbDataAdapter(sSQL,myConnection)
>
>
> Dim MyDataSet As New DataSet
>
> myAdapter.Fill(MyDataSet)
>
>
> GridView1.DataSource = MyDataSet
>
> GridView1.DataBind()
>
> myConnection.Close()
>
> End Sub
>
>
> I know the connection object is good because I use it else where, I have
> edited out from the event above.
>
> I have the require Namespaces , so it must be syntax, but I cannot for the
> life of me see what the problem is.
>
> Can anyone else?
>

good catch, I did not see this one.


"sloan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
>
> GridView1.DataSource = MyDataSet.Tables[0];
>
>
> A DataSet is a collection of DataTables.
>
> You have to pick a Table.
>
>
>
>
> "Paul W Smith" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Protected Sub Page_Load(ByVal sender As Object, ByVal e As
>> System.EventArgs)
>>
>> [connection object creation]
>>
>> Dim sSQL As String = "SELECT * FROM tPlayers"
>>
>> Dim myAdapter As OleDbDataAdapter = New
>> OleDbDataAdapter(sSQL,myConnection)
>>
>>
>> Dim MyDataSet As New DataSet
>>
>> myAdapter.Fill(MyDataSet)
>>
>>
>> GridView1.DataSource = MyDataSet
>>
>> GridView1.DataBind()
>>
>> myConnection.Close()
>>
>> End Sub
>>
>>
>> I know the connection object is good because I use it else where, I have
>> edited out from the event above.
>>
>> I have the require Namespaces , so it must be syntax, but I cannot for
>> the life of me see what the problem is.
>>
>> Can anyone else?
>>
>
>

You can also do this as a DEBUG technique.

string x = MyDataSet.GetXml();

or (vb.net)
dim x as string = MyDataSet.GetXml()

...

Look at the x value, and make sure you have information in there.




"sloan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
>
> GridView1.DataSource = MyDataSet.Tables[0];
>
>
> A DataSet is a collection of DataTables.
>
> You have to pick a Table.
>
>
>
>
> "Paul W Smith" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Protected Sub Page_Load(ByVal sender As Object, ByVal e As
>> System.EventArgs)
>>
>> [connection object creation]
>>
>> Dim sSQL As String = "SELECT * FROM tPlayers"
>>
>> Dim myAdapter As OleDbDataAdapter = New
>> OleDbDataAdapter(sSQL,myConnection)
>>
>>
>> Dim MyDataSet As New DataSet
>>
>> myAdapter.Fill(MyDataSet)
>>
>>
>> GridView1.DataSource = MyDataSet
>>
>> GridView1.DataBind()
>>
>> myConnection.Close()
>>
>> End Sub
>>
>>
>> I know the connection object is good because I use it else where, I have
>> edited out from the event above.
>>
>> I have the require Namespaces , so it must be syntax, but I cannot for
>> the life of me see what the problem is.
>>
>> Can anyone else?
>>
>
>

Paul,
If it isn't working that means your code is likely throwing an exception.
But - you don't have it wired up to catch exceptions. Wrap the whole thing
in a try / catch block and in the catch block you can output the exception's
Message and StackTrace properties to the debug window and even set a
breakpoint on the debug.WriteLine statement and mouse over the exception
object to examine it with Text Visualizer from Intellisense. That's faster
than asking questions on newsgroups and waiting around for answers!
-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com



"Paul W Smith" wrote:

> Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
>
> [connection object creation]
>
> Dim sSQL As String = "SELECT * FROM tPlayers"
>
> Dim myAdapter As OleDbDataAdapter = New
> OleDbDataAdapter(sSQL,myConnection)
>
>
> Dim MyDataSet As New DataSet
>
> myAdapter.Fill(MyDataSet)
>
>
> GridView1.DataSource = MyDataSet
>
> GridView1.DataBind()
>
> myConnection.Close()
>
> End Sub
>
>
> I know the connection object is good because I use it else where, I have
> edited out from the event above.
>
> I have the require Namespaces , so it must be syntax, but I cannot for the
> life of me see what the problem is.
>
> Can anyone else?
>
>
>

"sloan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

> GridView1.DataSource = MyDataSet.Tables[0];
>
> A DataSet is a collection of DataTables.

Yes it is.

> You have to pick a Table.

No you don't - if the DataSet has only one table, you don't need to specify
it...

GridView1.DataSource = MyDataSet


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

"Paul W Smith" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...

> I have the require Namespaces , so it must be syntax, but I cannot for the
> life of me see what the problem is.
>
> Can anyone else?

You've forgotten the Command object...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

"IfThenElse" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

>> A DataSet is a collection of DataTables.
>>
>> You have to pick a Table.

> good catch, I did not see this one.

Makes no difference if the DataSet has only one Table...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net