typed dataset xsd

[Rotsey]

Hi,

I have created a typed dataset (xsd file) with 2 tables and a relation
between them
in VS2005.

How I do I now bind that dataset to a Gridview??

When i do this the page is blank.

ds = New DataSet1()

gridview1.Datasource = ds
gridview1.DataBind()
Example code would be helpful cause I am lost??

rotsey

[sloan]

You have to pick one of the tables.

gridview1.Datasource = ds.Tables[0];
gridview1.DataBind()

And you probably have to define some fields (boundColumns?) in the Grid
itself.

"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:eB**************@TK2MSFTNGP05.phx.gbl...

Hi,

I have created a typed dataset (xsd file) with 2 tables and a relation
between them
in VS2005.

How I do I now bind that dataset to a Gridview??

When i do this the page is blank.

ds = New DataSet1()

gridview1.Datasource = ds
gridview1.DataBind()
Example code would be helpful cause I am lost??

rotsey

[Manish Bafna]

Hi,
There are more than one table in your dataset.So you need to set datamember
property of the gridview also.You will find complete working code in the
following URL :
http://www.samspublishing.com/articl...p?p=25460&rl=1

Thanks and regards,
manish bafna

"Rotsey" wrote:

Hi,

I have created a typed dataset (xsd file) with 2 tables and a relation
between them
in VS2005.

How I do I now bind that dataset to a Gridview??

When i do this the page is blank.

ds = New DataSet1()

gridview1.Datasource = ds
gridview1.DataBind()
Example code would be helpful cause I am lost??

rotsey

[Scott M.]

Making an instance of a typed dataset is only step one. You need to
populate it with data before a grid that is bound to it would show anything.
"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:eB**************@TK2MSFTNGP05.phx.gbl...

Hi,

I have created a typed dataset (xsd file) with 2 tables and a relation
between them
in VS2005.

How I do I now bind that dataset to a Gridview??

When i do this the page is blank.

ds = New DataSet1()

gridview1.Datasource = ds
gridview1.DataBind()
Example code would be helpful cause I am lost??

rotsey

[Rad [Visual C# MVP]]

On Sun, 10 Dec 2006 00:03:56 +1100, Rotsey wrote:

Hi,

I have created a typed dataset (xsd file) with 2 tables and a relation
between them
in VS2005.

How I do I now bind that dataset to a Gridview??

When i do this the page is blank.

ds = New DataSet1()

gridview1.Datasource = ds
gridview1.DataBind()

Example code would be helpful cause I am lost??

rotsey

You don't seem to be populating your dataset with any data! Also, if there
is more than one table, you need to set the datamember property to one of
the tables
--
Bits.Bytes
http://bytes.thinkersroom.com

[Rotsey]

Guys,

I realize I have to populate the dataset.

I am trying to create a Grdview with nested data
ie showing parent/child rows.

I have found out doing some googling that all I do is
set up a relation in the dataset between the 2 tables
and then bind it to a grdiview and it will do the rest.

I have this code now.
Dim dtProj As DataSet1.ProjectsDataTable

Dim dtUser As DataSet1.UsersDataTable

dtProj = New DataSet1TableAdapters.ProjectsTableAdapter().GetPr ojects

dtUser = New DataSet1TableAdapters.UsersTableAdapter().GetUsers

Me.GridView1.DataSource = dtProj

Me.DataBind()

Here I am only binding one table. How do I bind the dataset???????

rotsey


"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:eB**************@TK2MSFTNGP05.phx.gbl...

Hi,

I have created a typed dataset (xsd file) with 2 tables and a relation
between them
in VS2005.

How I do I now bind that dataset to a Gridview??

When i do this the page is blank.

ds = New DataSet1()

gridview1.Datasource = ds
gridview1.DataBind()
Example code would be helpful cause I am lost??

rotsey

[Scott M.]

You are already binding your GridView to a table in the dataset. That's all
you need.
"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:u8**************@TK2MSFTNGP06.phx.gbl...

Guys,

I realize I have to populate the dataset.

I am trying to create a Grdview with nested data
ie showing parent/child rows.

I have found out doing some googling that all I do is
set up a relation in the dataset between the 2 tables
and then bind it to a grdiview and it will do the rest.

I have this code now.
Dim dtProj As DataSet1.ProjectsDataTable

Dim dtUser As DataSet1.UsersDataTable

dtProj = New DataSet1TableAdapters.ProjectsTableAdapter().GetPr ojects

dtUser = New DataSet1TableAdapters.UsersTableAdapter().GetUsers

Me.GridView1.DataSource = dtProj

Me.DataBind()

Here I am only binding one table. How do I bind the dataset???????

rotsey


"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:eB**************@TK2MSFTNGP05.phx.gbl...

>Hi,

I have created a typed dataset (xsd file) with 2 tables and a relation
between them
in VS2005.

How I do I now bind that dataset to a Gridview??

When i do this the page is blank.

ds = New DataSet1()

gridview1.Datasource = ds
gridview1.DataBind()
Example code would be helpful cause I am lost??

rotsey

[Rotsey]

But I am trying to bind to the dataset.

So how do you get the parent/child functionality in the
gridview??????????????/
"Scott M." <s-***@nospam.nospamwrote in message
news:uC**************@TK2MSFTNGP06.phx.gbl...

You are already binding your GridView to a table in the dataset. That's
all you need.
"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:u8**************@TK2MSFTNGP06.phx.gbl...

>Guys,

I realize I have to populate the dataset.

I am trying to create a Grdview with nested data
ie showing parent/child rows.

I have found out doing some googling that all I do is
set up a relation in the dataset between the 2 tables
and then bind it to a grdiview and it will do the rest.

I have this code now.
Dim dtProj As DataSet1.ProjectsDataTable

Dim dtUser As DataSet1.UsersDataTable

dtProj = New DataSet1TableAdapters.ProjectsTableAdapter().GetPr ojects

dtUser = New DataSet1TableAdapters.UsersTableAdapter().GetUsers

Me.GridView1.DataSource = dtProj

Me.DataBind()

Here I am only binding one table. How do I bind the dataset???????

rotsey


"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:eB**************@TK2MSFTNGP05.phx.gbl...

>>Hi,

I have created a typed dataset (xsd file) with 2 tables and a relation
between them
in VS2005.

How I do I now bind that dataset to a Gridview??

When i do this the page is blank.

ds = New DataSet1()

gridview1.Datasource = ds
gridview1.DataBind()
Example code would be helpful cause I am lost??

rotsey

[sloan]

http://www.google.com/search?hl=en&q=gridview+nested

http://www.codeguru.com/columns/vb/article.php/c12647/

"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:eB**************@TK2MSFTNGP05.phx.gbl...

Hi,

I have created a typed dataset (xsd file) with 2 tables and a relation
between them
in VS2005.

How I do I now bind that dataset to a Gridview??

When i do this the page is blank.

ds = New DataSet1()

gridview1.Datasource = ds
gridview1.DataBind()
Example code would be helpful cause I am lost??

rotsey

[Rotsey]

thanks sloan.

but I was lead to believe that I could point a dataset at a gridview

and it would render the grid with + and - where you could
expand and collapse rows.

is this just fantasy land??????

I just had a thought, as I don't want edit capability would
crystal reports do the job??????????????

"sloan" <sl***@ipass.netwrote in message
news:er*************@TK2MSFTNGP04.phx.gbl...

http://www.google.com/search?hl=en&q=gridview+nested

http://www.codeguru.com/columns/vb/article.php/c12647/

"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:eB**************@TK2MSFTNGP05.phx.gbl...

>Hi,

I have created a typed dataset (xsd file) with 2 tables and a relation
between them
in VS2005.

How I do I now bind that dataset to a Gridview??

When i do this the page is blank.

ds = New DataSet1()

gridview1.Datasource = ds
gridview1.DataBind()
Example code would be helpful cause I am lost??

rotsey

[Scott M.]

You don't point DataSets at controls, you point controls a data sources
(such as DataSets).
"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:ew**************@TK2MSFTNGP06.phx.gbl...

thanks sloan.

but I was lead to believe that I could point a dataset at a gridview

and it would render the grid with + and - where you could
expand and collapse rows.

is this just fantasy land??????

I just had a thought, as I don't want edit capability would
crystal reports do the job??????????????

"sloan" <sl***@ipass.netwrote in message
news:er*************@TK2MSFTNGP04.phx.gbl...

>http://www.google.com/search?hl=en&q=gridview+nested

http://www.codeguru.com/columns/vb/article.php/c12647/

"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:eB**************@TK2MSFTNGP05.phx.gbl...

>>Hi,

I have created a typed dataset (xsd file) with 2 tables and a relation
between them
in VS2005.

How I do I now bind that dataset to a Gridview??

When i do this the page is blank.

ds = New DataSet1()

gridview1.Datasource = ds
gridview1.DataBind()
Example code would be helpful cause I am lost??

rotsey

[Rotsey]

so intelligent....but not enough to answer the question.
"Scott M." <s-***@nospam.nospamwrote in message
news:%2***************@TK2MSFTNGP06.phx.gbl...

You don't point DataSets at controls, you point controls a data sources
(such as DataSets).
"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:ew**************@TK2MSFTNGP06.phx.gbl...

>thanks sloan.

but I was lead to believe that I could point a dataset at a gridview

and it would render the grid with + and - where you could
expand and collapse rows.

is this just fantasy land??????

I just had a thought, as I don't want edit capability would
crystal reports do the job??????????????

"sloan" <sl***@ipass.netwrote in message
news:er*************@TK2MSFTNGP04.phx.gbl...

>>http://www.google.com/search?hl=en&q=gridview+nested

http://www.codeguru.com/columns/vb/article.php/c12647/

"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:eB**************@TK2MSFTNGP05.phx.gbl...
Hi,

I have created a typed dataset (xsd file) with 2 tables and a relation
between them
in VS2005.

How I do I now bind that dataset to a Gridview??

When i do this the page is blank.

ds = New DataSet1()

gridview1.Datasource = ds
gridview1.DataBind()
Example code would be helpful cause I am lost??

rotsey

[Scott M.]

And, if you'd like to continue being sarcastic, you'll have a hard time
getting any information. I was simply trying to alert you to the basic
premis of databinding, which by your question seemed like it needed some
enlightenment.
"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:uJ**************@TK2MSFTNGP03.phx.gbl...

so intelligent....but not enough to answer the question.
"Scott M." <s-***@nospam.nospamwrote in message
news:%2***************@TK2MSFTNGP06.phx.gbl...

>You don't point DataSets at controls, you point controls a data sources
(such as DataSets).
"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:ew**************@TK2MSFTNGP06.phx.gbl...

>>thanks sloan.

but I was lead to believe that I could point a dataset at a gridview

and it would render the grid with + and - where you could
expand and collapse rows.

is this just fantasy land??????

I just had a thought, as I don't want edit capability would
crystal reports do the job??????????????

"sloan" <sl***@ipass.netwrote in message
news:er*************@TK2MSFTNGP04.phx.gbl...
http://www.google.com/search?hl=en&q=gridview+nested

http://www.codeguru.com/columns/vb/article.php/c12647/

"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:eB**************@TK2MSFTNGP05.phx.gbl...
Hi,
>
I have created a typed dataset (xsd file) with 2 tables and a relation
between them
in VS2005.
>
How I do I now bind that dataset to a Gridview??
>
When i do this the page is blank.
>
ds = New DataSet1()
>
gridview1.Datasource = ds
gridview1.DataBind()
>
>
Example code would be helpful cause I am lost??
>
rotsey
>
>
>

[Rotsey]

fine.....it sounded like a smart comment.....I apologize
"Scott M." <s-***@nospam.nospamwrote in message
news:eQ**************@TK2MSFTNGP06.phx.gbl...

And, if you'd like to continue being sarcastic, you'll have a hard time
getting any information. I was simply trying to alert you to the basic
premis of databinding, which by your question seemed like it needed some
enlightenment.
"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:uJ**************@TK2MSFTNGP03.phx.gbl...

>so intelligent....but not enough to answer the question.
"Scott M." <s-***@nospam.nospamwrote in message
news:%2***************@TK2MSFTNGP06.phx.gbl...

>>You don't point DataSets at controls, you point controls a data sources
(such as DataSets).
"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:ew**************@TK2MSFTNGP06.phx.gbl...
thanks sloan.

but I was lead to believe that I could point a dataset at a gridview

and it would render the grid with + and - where you could
expand and collapse rows.

is this just fantasy land??????

I just had a thought, as I don't want edit capability would
crystal reports do the job??????????????

"sloan" <sl***@ipass.netwrote in message
news:er*************@TK2MSFTNGP04.phx.gbl...
http://www.google.com/search?hl=en&q=gridview+nested
>
http://www.codeguru.com/columns/vb/article.php/c12647/
>
>
>
"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:eB**************@TK2MSFTNGP05.phx.gbl.. .
>Hi,
>>
>I have created a typed dataset (xsd file) with 2 tables and a
>relation
>between them
>in VS2005.
>>
>How I do I now bind that dataset to a Gridview??
>>
>When i do this the page is blank.
>>
>ds = New DataSet1()
>>
>gridview1.Datasource = ds
>gridview1.DataBind()
>>
>>
>Example code would be helpful cause I am lost??
>>
>rotsey
>>
>>
>>
>
>