GridView doesn't refresh schema after changes were made in bounded stored procedure

O

Orit

Hi .

I am creating an ASP.NET 2.0 web site and have the following problem :

1. I have a GridView which bound to the object data source.
2. This object data source is SQL Table adapter that I added to the
data set via IDE .
3. The method GetData of this table adapter uses existing stored
procedure on my SQL 2005 server.
4. Everything worked fine , until I made a changes to the stored
procedure ( the new result dataset records have additional fields ) .

The problem is :

The new fields don't appear in the grid .
Note : When I right click to the GetData method inside the table
adapter and select "Preview Data" , it SHOWS the new fields retrieved
by this sproc .
I tried to press "Refresh schema" in all possible places - it didn't
help .
The only way I was able to solve the issue is to create a NEW table
adapter , to add AGAIN all methods , to bind AGAIN the grid , to edit
AGAIN all fields of the grid ....
It looks like a IDE bug, or (hopefully) I am missing something ....


I may need to change the sproc in the future , so I am looking for the
way to see the changes in the grid WITHOUT doing all those steps
above .

Please advice !

Thanks in advance ,
Orit Chanukov .
 
M

Masudur

Hi .

I am creating an ASP.NET 2.0 web site and have the following problem :

1. I have a GridView which bound to the object data source.
2. This object data source is SQL Table adapter that I added to the
data set via IDE .
3. The method GetData of this table adapter uses existing stored
procedure on my SQL 2005 server.
4. Everything worked fine , until I made a changes to the stored
procedure ( the new result dataset records have additional fields ) .

The problem is :

The new fields don't appear in the grid .
Note : When I right click to the GetData method inside the table
adapter and select "Preview Data" , it SHOWS the new fields retrieved
by this sproc .
I tried to press "Refresh schema" in all possible places - it didn't
help .
The only way I was able to solve the issue is to create a NEW table
adapter , to add AGAIN all methods , to bind AGAIN the grid , to edit
AGAIN all fields of the grid ....
It looks like a IDE bug, or (hopefully) I am missing something ....

I may need to change the sproc in the future , so I am looking for the
way to see the changes in the grid WITHOUT doing all those steps
above .

Please advice !

Thanks in advance ,
Orit Chanukov .

Hi...

its really very annoying ... but i didn't find any problem...
okay just in case... swith to design view to html view and then again
html view to design view...
then press refresh schema in objectdatasource and then grid...

Thanks
Masudur
http://munnacs.110mb.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,904
Latest member
HealthyVisionsCBDPrice

Latest Threads

Top