I am using the Views to get the values from the Database. I am updating the rows by using my C# code. It is updating the columns but the values getting through views is giving the old values. When I refresh the Views its giving the correct values. Can any
one help me to solve this issue.
kadhar2006
Member
32 Points
78 Posts
Views are not working after the rows are updated
Nov 21, 2012 10:38 AM|LINK
Hi,
I am using the Views to get the values from the Database. I am updating the rows by using my C# code. It is updating the columns but the values getting through views is giving the old values. When I refresh the Views its giving the correct values. Can any one help me to solve this issue.
Thanks in Advance
jagjot
Contributor
2648 Points
1229 Posts
Re: Views are not working after the rows are updated
Nov 21, 2012 10:42 AM|LINK
need more information...
Are you displaying values in gridview control.?
How you refresh your views?
M.Sc, MIEEE, MCP, CCNA
kadhar2006
Member
32 Points
78 Posts
Re: Views are not working after the rows are updated
Nov 21, 2012 11:12 AM|LINK
Hi,
Ya I am filling that values to grid. I am refreshing the Views at the backend like Script to-->Alter View and then executing that views.
Thanks
jagjot
Contributor
2648 Points
1229 Posts
Re: Views are not working after the rows are updated
Nov 21, 2012 11:16 AM|LINK
after you are done updating your views try YourGird.Bind() again.
M.Sc, MIEEE, MCP, CCNA
kadhar2006
Member
32 Points
78 Posts
Re: Views are not working after the rows are updated
Nov 21, 2012 11:27 AM|LINK
Ya I tried But it not working. The problem is from view itself there itself it's not selecting the new values it gives only the old record
jagjot
Contributor
2648 Points
1229 Posts
Re: Views are not working after the rows are updated
Nov 21, 2012 11:29 AM|LINK
what is your database? sql server ?
M.Sc, MIEEE, MCP, CCNA
kadhar2006
Member
32 Points
78 Posts
Re: Views are not working after the rows are updated
Nov 21, 2012 11:35 AM|LINK
Yes, I am using SQL Server 2008
jagjot
Contributor
2648 Points
1229 Posts
Re: Views are not working after the rows are updated
Nov 21, 2012 12:16 PM|LINK
can you post your code?
M.Sc, MIEEE, MCP, CCNA