how i can make aclass contains method connect to a database and return sqlconnection

Question

0.00/5 (No votes)

See more:

how i can make aclass contains method connect to a database and return sqlconnectionMake a class call it dbconnection Add function
connection (string Connectionstring )to connect to data base
and return sqlsonnection Add function GetDataTable(string sql)
to return datatableAdd function ExecuteSql(string sql) to run
sql script And please make all functions static functions
This class to use it in connecting DB in the purchasing project

Posted 18-Sep-11 13:04pm

mhassan083

Updated 18-Sep-11 13:39pm

v2

Add a Solution

2 solutions

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)

Simon Bang Terkildsen · Answer 1 · 2011-09-18T13:13:00

Solution 1

Your question is not very clear, yet here is my five cents.

0) Make a class
1) Make a method
2) Look at ADO.NET[^]. This is the first in a series of articles on ADO.NET[^]

To the updated question.
My previous answer still applies. Though this statement: "And please make all functions static functions" seems to indicate you are of the belief that we'll do your homework for you. You should already have enough information to get started.

Posted 18-Sep-11 13:13pm

Simon Bang Terkildsen

Updated 18-Sep-11 14:03pm

v2

Comments

Sergey Alexandrovich Kryukov 18-Sep-11 21:01pm

My 5. I added a bit more concrete solution to the problem as I understood it. I thing the issue is to separate things specific to a concrete provider from the instances of the classes which can be used in any code. Please see my solution.
--SA

Sergey Alexandrovich Kryukov · Answer 2 · 2011-09-18T15:00:00

I would advice to look at this simple article first: Using ADO.NET for beginners[^].

Take a look at the diagram where you see relationships between DbConnection, DataAdapter and DataReader. The problem is: you cannot abstract connection from data provider. It is provider-specific. You need to create an instance of DataAdapter, DataReader or both using your connection string and some specific data provider you use. When you do it, you can return DataReader as the instance of the interface System.Data.IDataReader and the DataAdapter as the instance of the interface System.Data.IDataAdapter, System.Data.IDbDataAdapter or the abstract class System.Data.Common.DbDataAdapter (with some more capabilities), depending on your task. These instances are agnostic to the provider and you can use them in any application.

—SA