Problem Adding a Column in a DataGrid

[Atley]

I have a Datagrid I have created, it's datasource is an XML Dataset that I
have created. That form worked perfectly, until I had to add a column to
the table... I did it in my database, it shows up in my database, in my xml
dataset, and I even add the column to my datagrid, but now that new column
doesn't retreive from the database or add new data to that column in the
table...

It seems like this one column is unbournd, even though I have mapped the
table field in the columnstyles...

What can I do!

Thanks in advance for any help.

[Rulin Hong]

Check SqlDataAdapter.SelectCommand.CommandText if CommandType is Text.
Check related stored-procedure if CommandType is StoredProcedure

Good luck

"Atley" wrote:

I have a Datagrid I have created, it's datasource is an XML Dataset that I
have created. That form worked perfectly, until I had to add a column to
the table... I did it in my database, it shows up in my database, in my xml
dataset, and I even add the column to my datagrid, but now that new column
doesn't retreive from the database or add new data to that column in the
table...

It seems like this one column is unbournd, even though I have mapped the
table field in the columnstyles...

What can I do!

Thanks in advance for any help.

[Atley]

Where do I find these properties?
"Rulin Hong" <Ru*******@discussions.microsoft.com> wrote in message
news:4A**********************************@microsof t.com...

Check SqlDataAdapter.SelectCommand.CommandText if CommandType is Text.
Check related stored-procedure if CommandType is StoredProcedure

Good luck

"Atley" wrote:

I have a Datagrid I have created, it's datasource is an XML Dataset that I have created. That form worked perfectly, until I had to add a column to the table... I did it in my database, it shows up in my database, in my xml dataset, and I even add the column to my datagrid, but now that new column doesn't retreive from the database or add new data to that column in the
table...

It seems like this one column is unbournd, even though I have mapped the
table field in the columnstyles...

What can I do!

Thanks in advance for any help.

[Rulin Hong]

How do you get data from database to fill into DataSet?
Can you paste your source code?

"Rulin Hong" wrote:

Check SqlDataAdapter.SelectCommand.CommandText if CommandType is Text.
Check related stored-procedure if CommandType is StoredProcedure

Good luck

"Atley" wrote:

I have a Datagrid I have created, it's datasource is an XML Dataset that I
have created. That form worked perfectly, until I had to add a column to
the table... I did it in my database, it shows up in my database, in my xml
dataset, and I even add the column to my datagrid, but now that new column
doesn't retreive from the database or add new data to that column in the
table...

It seems like this one column is unbournd, even though I have mapped the
table field in the columnstyles...

What can I do!

Thanks in advance for any help.

[Cor Ligthert]

Hi Atley,

We are not all using the the same methods, I expect while reading this,
that you have created the dataset using the designer, while you have
probably as well done your SQL select string with that.

When my gues is right, than I give you the most change when you create that
selectstring againg using the AdapterWizard, right clicking on the adapter
below on your screen. And than not forget to regenerate the dataset as well
right clicking on the adapter to choose that.

Just a gues

I hope this helps?

Cor

I have a Datagrid I have created, it's datasource is an XML Dataset that I
have created. That form worked perfectly, until I had to add a column to
the table... I did it in my database, it shows up in my database, in my xml dataset, and I even add the column to my datagrid, but now that new column
doesn't retreive from the database or add new data to that column in the
table...

It seems like this one column is unbournd, even though I have mapped the
table field in the columnstyles...

What can I do!

Thanks in advance for any help.

[Atley]

Where do I find the AdapterWizard?

I used the DataForm Wizard...


"Cor Ligthert" <no**********@planet.nl> wrote in message
news:O0**************@TK2MSFTNGP11.phx.gbl...

Hi Atley,

We are not all using the the same methods, I expect while reading this,
that you have created the dataset using the designer, while you have
probably as well done your SQL select string with that.

When my gues is right, than I give you the most change when you create that selectstring againg using the AdapterWizard, right clicking on the adapter
below on your screen. And than not forget to regenerate the dataset as well right clicking on the adapter to choose that.

Just a gues

I hope this helps?

Cor

I have a Datagrid I have created, it's datasource is an XML Dataset that I have created. That form worked perfectly, until I had to add a column to the table... I did it in my database, it shows up in my database, in my

xml

dataset, and I even add the column to my datagrid, but now that new column doesn't retreive from the database or add new data to that column in the
table...

It seems like this one column is unbournd, even though I have mapped the
table field in the columnstyles...

What can I do!

Thanks in advance for any help.

[Cor Ligthert]

Hi Atley,

Than there is a lot build automaticly however I would not know how to change
that in an easy way.

Maybe you can set a new message in this newsgroup and as well in these
newsgroups

microsoft.public.dotnet.framework.adonet
microsoft.public.dotnet.framework.windowforms
microsoft.public.dotnet.framework.windowforms.desi gntime

Crossposted what means one message with 4 newsgroups in the adres seperated
by a comma.
And tell that you are using the dataform (wizard)

I hope you find your solution.

Cor

Where do I find the AdapterWizard?

I used the DataForm Wizard...


"Cor Ligthert" <no**********@planet.nl> wrote in message
news:O0**************@TK2MSFTNGP11.phx.gbl...

Hi Atley,

We are not all using the the same methods, I expect while reading this,
that you have created the dataset using the designer, while you have
probably as well done your SQL select string with that.

When my gues is right, than I give you the most change when you create that

selectstring againg using the AdapterWizard, right clicking on the adapter

below on your screen. And than not forget to regenerate the dataset as

well

right clicking on the adapter to choose that.

Just a gues

I hope this helps?

Cor

I have a Datagrid I have created, it's datasource is an XML Dataset that I have created. That form worked perfectly, until I had to add a column to the table... I did it in my database, it shows up in my database, in

my

xml

dataset, and I even add the column to my datagrid, but now that new

column doesn't retreive from the database or add new data to that column in

the table...

It seems like this one column is unbournd, even though I have mapped the table field in the columnstyles...

What can I do!

Thanks in advance for any help.