How can be make dll file for connect to the remote server database & How can be use it

Question

1.00/5 (2 votes)

See more:

Hello Sir ,

I want to know that how can be create .dll file & how can connect database sqlser to .dll file in asp.net C#

Posted 26-Sep-12 2:02am

Rachana Gaur

Add a Solution

Comments

Stephen Hewison 26-Sep-12 8:17am

This isn't a very clear question. Perhaps a little more information about what you're trying to do?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

I.explore.code · Accepted Answer · 2012-09-26T03:08:00

I am going to try to answer what I think your question is which is "how do I structure my code so that the database connectivity is handled in a separate dll?". If this is not the case, then please let me know and i will remove this solution.

What you need is an n-tier architecture and this Creating ASP.NET Applications with N-Tier Architecture[^] is one of the millions of articles you can refer to via Google.

Basically, you will have a Business Layer a separate C# class library project i.e. a dll, a Data Access Layer as another separate C# class library project i.e. a dll and a presentation layer typically a web-forms ASP.NET application which will have a dll and aspx pages for the UI. The Data Access Layer (DAL) would be the dll where your data access code will go. If the database server is on another computer (VM or physical), then you would need the appropriate connection string for that machine and make sure your database server is set to allow remote TCP connections. Let me know if this helps or not.

Cheers