Problem Adding a Column in a DataGrid

  • Thread starter Thread starter Atley
  • Start date Start date
A

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.
 
Check SqlDataAdapter.SelectCommand.CommandText if CommandType is Text.
Check related stored-procedure if CommandType is StoredProcedure

Good luck
 
Where do I find these properties?


Rulin Hong said:
Check SqlDataAdapter.SelectCommand.CommandText if CommandType is Text.
Check related stored-procedure if CommandType is StoredProcedure

Good luck
 
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
 
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.designtime

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
 
Back
Top