Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > GridView doesn't refresh schema after changes were made in bounded stored procedure

Reply
Thread Tools

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

 
 
Orit
Guest
Posts: n/a
 
      06-26-2007
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 .

 
Reply With Quote
 
 
 
 
Masudur
Guest
Posts: n/a
 
      06-26-2007
On Jun 26, 11:21 pm, Orit <(E-Mail Removed)> wrote:
> 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

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically refresh page when changes had been made to the page Harry Bellafonte HTML 0 11-08-2007 12:24 PM
'Procedure or function <stored procedure name> has too many arguments specified',,,ARGH! Mike P ASP .Net 0 06-19-2006 01:19 PM
Gridview sorting - with template columns and stored procedure =?Utf-8?B?RG9ydGU=?= ASP .Net 0 12-14-2005 06:58 AM
[XML Schema] Including a schema document with absent target namespace to a schema with specified target namespace Stanimir Stamenkov XML 3 04-25-2005 09:59 AM
Failed to get schema for this stored procedure DC Gringo ASP .Net 1 09-08-2004 02:54 PM



Advertisments