Deployment of DataSets (xsd files)

[Goldenrate]

Hi,

I'm developing a DotNetNuke module using c#. I have my local station and my
own dedicated server. On both stations I have MSSQL2008 running.

As part of the module development I created a separated class project. This
class project communicates with MSSQL database and contained the business
logic layer(BLL) and of course the data access layer(DAL). I've created the
DAL using the graphic tools of the DataSet in VS2008. That is, I simply
dragged tables from the server explorer to the database and created class
that communicate with them in the BLL. I complied the project and used it
locally. It was working fine.

When I deployed it (including putting the dll file in the bin directory), it
didn't work. I don't know if the DataSet automatically acquires the name of
the string or should I do anything about it.

Does anyone have any idea?

Thanks,
David

 

[\Ji Zhou [MSFT]\]

Hello David,

Based on my understanding, the DataSet.xsd file does not need to be
deployed. It is used in the Visual Studio to make a visual UI which can
help us to design the dataset structure. When our application runs in the
client machine, the dataset structure information will be compiled into the
output assembly as typed dataset. The .xsd file is no more necessary.

To give a future support on this case, would you mind letting me know what
you mean on saying "When I deployed it (including putting the dll file in
the bin directory), it didn't work." Have you seen any error thrown from
your application? If yes, what is the exception message and what is the
exception stack? I collect this information for a future analyzing on your
problem. Look forward your reply and thanks for your cooperation!

Have a good day!


Best regards,
Ji Zhou ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://support.microsoft.com/select/default.aspx?target=assistance&ln=en-us.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Goldenrate]

Hi Ji,

Thank you.

The message error is general:
Sys.WebForms.PageRequestManageParseErrorException: The message received from
the server could not be parsed. I suspect it has to do with the database as
the problem occurs when I click the button that invokes the Insert method
(its basically a wizard bases form that initiates update to the DB in every
step).

The class (name it MyClass) I've developed contained the typed DataSet and
is responsible of the communication with the server. I don't know how it
really works but I know that locally MyClass connected to the database using
the local connection string (call it localConString). Obviously I should
change the name of the connection string before I deploy it (or so I think),
since the name of the connection string on the server is different.

Please let me know if you need more clarifications,

All best,
David

Hello David,

Based on my understanding, the DataSet.xsd file does not need to be
deployed. It is used in the Visual Studio to make a visual UI which can
help us to design the dataset structure. When our application runs in the
client machine, the dataset structure information will be compiled into
the
output assembly as typed dataset. The .xsd file is no more necessary.

it didn't work." Have you seen any error thrown from

 

[\Ji Zhou [MSFT]\]

Hello David,

I do some future research on the
Sys.WebForms.PageRequestManagerParserErrorException exception. It seems all
information searched out from the Internet indicates we may encounter this
exception if using AJAX UpdatePanel. So do you use the AJAX components in
your projects? You can get some future more information related to the
exception in the following article,
http://weblogs.asp.net/leftslipper/archive/2007/02/26/sys-webforms-pagereque
stmanagerparsererrorexception-what-it-is-and-how-to-avoid-it.aspx
Please let me know if the workarounds in this article helps in your
scenario.

Since it throws the exception when the user click the button, would you
mind posting the codes in the button's click event handle.
Yes, we need to change the connection string to deploy it to another
computer. Usually, we can put the connection string in the web.config file.
In the codes, we read the connection string from the web.config file. So,
after deployment, we just need to change the web.config connection string
section instead of modifying the hard code. See the MSDN document
http://msdn.microsoft.com/en-us/library/ms178411.aspx.

And make sure your SQL Server can be remote connected, see
http://support.microsoft.com/kb/914277.

Meantime, I suggest you post the ASP.NET related questions in the
microsoft.public.dotnet.framework.aspnet newsgroup. Choosing an appropriate
newsgroup lets more community members who are good at that technology can
see your post. They may encounter the issue before and give useful
suggestion.

Have a good weekend David!

Best regards,
Ji Zhou ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[\Ji Zhou [MSFT]\]

Hello David,

I am writing to check the status of the issue on your side. Could you
please let me know if the suggestion works for you or not? If you have any
questions or concerns, please feel free to let me know. I will be more than
happy to be of assistance.

Have a great day!

Best regards,
Ji Zhou ([email protected], remove 'online.')
Microsoft Online Community Support