SQL changes are not reflecting on VB.et after Datasource configuration wizard
Hi all,
I have a strange problem that occurred with me and I am not able to solve.
I
deleted a field from SQL 2000 query, then I went to my VB.net 2008 and
hit the Datasource configuration wizard to update the changes,
Everything was ok and I unselected the red exclamation mark which is the
field I deleted, it was working fine so far.
Moreover, in the
Datasource pane, the field that I deleted is no longer exists and so it
doesn't exist in the Dataset designer which is correct.
HERE IS
THE PROBLEM, when I drag and drop the table that I edited as a
datagridview then the field I had deleted is still appearing and no
errors appears until I run my program and load the form that includes
this table (it is saying "Column is not found"). So How to reflect the
changes I made in this case.
Note that, it is the first time this case happens with me coz I always make changes and it is wasn't an issue.
Thanks in advance
FIras Daw
Answers (4)
1
Hi, Thanks I removed httpUtility.UrlEncode from view.aspx page and it worked.
1
Hi..
Welcome to Csharpcorner
Normally this error occur when we are trying to access the resource which is not available. In your case check out view.aspx location means see is it present in any directory.If it is then try like
Hyperlink.NavigateUrl = "~/view.aspx?ReturnUrl=" +
HttpUtility.UrlEncode(Request.Url.AbsolutePath);
As well your target url must be able to Decode.