Sharing SqlConnection across a project

Question

0.00/5 (No votes)

See more:

So I have a bit of code in each form to connected to SQL databases...

C#

private SqlConnection connectLink(string selectDbase)
        {
            SqlConnection returnCon = null;
            try
            {
                returnCon = new SqlConnection("Data Source=" + Properties.Settings.Default.sqlServer + ";"
                        + "Initial Catalog=" + selectDbase + ";"
                        + "Persist Security Info=True;"
                        + "User ID=" + Properties.Settings.Default.dBaseUname + ";Password=" + unScramble(Properties.Settings.Default.dBasePword));
            }
            catch
            {
                MessageBox.Show("There was an error connecting to the " + selectDbase + " Database");
            }
            return returnCon;
        }

Which I then call whenever I want to connect to a database...

C#

SqlConnection getDetails = connectLink(Properties.Settings.Default.linkDbase);

probably a dumb question but is there anyway I can have this sitting in a separate .cs file rather than in each forms code? I'm pretty new with C#...

Posted 16-Mar-12 6:15am

TenmanS14

Add a Solution

3 solutions

Solution 1

Please see this article
General purpose class to fill DataTable(s) from DataBase and to save DataTable(s) to DataBase using reflection[^]
After instantiating the DataBaseConnector class with connection string it can be used at several places, to fill and save the data in DataTables

Posted 16-Mar-12 6:25am

ProEnggSoft

Solution 2

see reference.
http://www.dotnetfunda.com/articles/article71.aspx[^]

Posted 16-Mar-12 6:47am

Bojjaiah

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)

Dylan Morley · Accepted Answer · 2012-03-16T06:55:00

Microsoft created a class for exactly this purpose, named SqlHelper. The source code is here...

http://www.koders.com/csharp/fidD4121D6E4BCA2DAB656D770903FECBFF7427D242.aspx[^]

You don't have to keep creating SQL Connections with this class, you can just send it your connection string to one of the overloads. e.g.

C#

string connectionString = "Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;"

// Get a dataset from a Straight text command
System.Data.DataSet results = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(connectionString, System.Data.CommandType.Text, "SELECT Field1 FROM Table5");


// Get a data reader from a stored procedure with parameters
int someParameter1 = 5;
string someParameter2 = "Test";
using (var reader = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(connectionString, "MyStoredProcedureName", someParameter1, someParameter2))
{
    while (reader.Read())
    {
        // do something
    }
}