4
Answers

SQL changes are not reflecting on VB.et after Datasource configuration wizard

firas daw

firas daw

14y
7k
1
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
programmerAt
NA 3 4.6k 14y
Hi, Thanks I removed httpUtility.UrlEncode from view.aspx page and it worked.
1
Krishna Garad
NA 16.5k 6.2m 14y
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.
Next Recommended Forum