This is a strange one. I opened a Web form with a Dataset, SqlConnection,
SqlAdapters and SqlCommands ( all selects). The SqlCommand used stored
procedures. The Web form is under VSS control and NOT checked out. I rebuild
the solution and ALL the SqlAdapters select properties lost their linkage to
the SqlCommands.
I had no problem recovering, just got the current copy of the form.
Has anybody else seen this problem? Is this a known problem?
Hi Jim,
>This is a strange one. I opened a Web form with a Dataset,
>SqlConnection, SqlAdapters and SqlCommands ( all selects).
[quoted text clipped - 4 lines]
>......
>Has anybody else seen this problem? Is this a known problem?
I have checked our internal database for this issue, but did not find a
similar case.
Considering you mentioned the Web form is under VSS control and you did not
check it out, does this problem happen if you check it out?
At meantime I suggest you post this issue to the group
microsoft.public.dotnet.framework.adonet, I think the guys there would have
lots of experience with the SqlAdapter and SqlCommand, wish you will get
more help there...
Thanks for your understanding!
Best regards,
Gary Chang
Microsoft Community Support
--------------------
Get Secure! ¡§C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
&SD=msdn
This posting is provided "AS IS" with no warranties, and confers no rights.
JimM - 08 Aug 2005 15:19 GMT
I am not sure. I only noticed that the properties lost the linkage to the
SqlCommand. The form was not checkout because no changes were occuring
there.
I needed to look at some code in the form because of an exception occuring
in the execution. Error was not in the form but a security setting on the
database. I wanted to look at the code.
I did a Solution Rebuild and poof many errors in the form source, the
linkage to the SQL commands were gone. Did a get on the file from VSS and
all was OK.
Just want to know if anyone had seen this error or if it was a know problem
with the IDE. Looked to me to be an IDE code generation/resource
specificaiton problem. Don't know way it would be a ADONET issue, but I'll
check over there.
Thanks

Signature
Jim
> Hi Jim,
>
[quoted text clipped - 31 lines]
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
"Gary Chang[MSFT]" - 09 Aug 2005 09:47 GMT
Hi Jim,
>Just want to know if anyone had seen this error or if it was a know
>problemwith the IDE. Looked to me to be an IDE code generation/resource
>specificaiton problem. Don't know way it would be a ADONET issue, but I'll
>check over there.
yes, it appears to be an IDE issue, but we couldn't repro it in local
environment. I think the ADONET group may have some community members who
experienced in the use of DataSet and SqlAdapter...
Thanks for your understanding!
Best regards,
Gary Chang
Microsoft Community Support
--------------------
Get Secure! ¡§C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
&SD=msdn
This posting is provided "AS IS" with no warranties, and confers no rights.