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

[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 .

[Masudur]

On Jun 26, 11:21 pm, Orit <[e-mail]:

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