sql connection in seperate class file using c#

Question

1.44/5 (2 votes)

See more:

SQL-Server-2005

C#

SqlConnection con = new SqlConnection("Server=server_name;Database=database_name;uid=userid;password=password");
con.Open();

I want to make a seperate class.cs file and can call this class whenever needed it will help me not to change userid and password in every place just change it in class file and its done how to do this.actually i have created the file but the problm is this how to use con object at the place of sqlcommand..the class must return con.or sumthing like that.

Posted 18-Aug-11 5:10am

namaskaaar

Updated 8-Feb-18 17:37pm

Herman<T>.Instance

v2

Add a Solution

Comments

Tota Dill 11-Sep-13 7:45am

how to use connection string class function that contain connection in other forms code

4 solutions

Solution 1

see my article http://www.codeproject.com/KB/tips/SqlParameters.aspx[^]
which holds classes for generic use in connecting to a database.

Posted 18-Aug-11 5:18am

Herman<T>.Instance

v2

Solution 2

for example you can make a new class : sqlParms.cs

then in that class you can create any function you want depending on the level you want to work on it : in simple cases you can create a function called getConn which return the connection string and the call it like that :

sqlParms prms=new sqlParms();
SqlConnection con=prms.getConn();

this is the simple way. other you can do more complicated work by using digimanus link ...
regards

Posted 18-Aug-11 8:31am

Tamer Hatoum

Solution 3

Hi,

Hope this help..

C#

class SqlCommandWrapper
{
   private string _connectionString;

   public string connectionString
   {
     get{ return _connectionString; }
     set{ _connectionString = value; }
   }

   public SqlCommandWrapper(string tcConnectionString)
   {
     this.connectionString = tcConnectionString;
   }

   public SqlCommand CreateCommand()
   {
     SqlCommand loReturnValue = new SqlCommand()
     {
        Connection = new SqlConnection(this.connectionString)
     }

     return loReturnValue;
   }
}

Posted 18-Aug-11 8:40am

NOTmii

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)

RaviRanjanKr · Accepted Answer · 2011-08-18T08:54:00

Solution 4

Try

C#

using System.Data.SqlClient;

class myConnection
    {
        public static SqlConnection GetConnection()
        {
            string str = "Data Source=.;Initial Catalog = YourDatabaseName;uid =sa;pwd = YourPassword";

            SqlConnection con = new SqlConnection(str);
            con.Open();
            return con;
        }
    }

Posted 18-Aug-11 8:54am

RaviRanjanKr

Comments

NISHAN SANDEEPA 22-Nov-12 23:16pm

SqlConnection con = new SqlConnection("data source=.;initial catalog=dbname;integrated security=true");
SqlDataAdapter da = new SqlDataAdapter();
da.InsertCommand = new SqlCommand("insert into tblReg values(@id,@name)", con);
da.InsertCommand.Parameters.Add("@id", SqlDbType.Int).Value = txtId.Text;
da.InsertCommand.Parameters.Add("@name", SqlDbType.VarChar).Value = txtName.Text;
con.Open();
da.InsertCommand.ExecuteNonQuery();
con.Close();
this is my normal method.
-------------------------------------------------------------------
I need to know, by creating a separate class like myConnection(given up) ....how I call this class in my main class.
help me by giving example.
because I am a beginner for c#.