how to access connection string from one class file to another class file

Question

0.00/5 (No votes)

See more:

in app_code, there are two folder
1. Connection
2. Login
connection class manage multiple connection string
code is:-

C#

public class Connection
{
    string conn;
  SqlConnection con;
    public Connection( string val)
    {
        if (val == "1")
        {
            conn = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
        }
        else if (val == "2")
            {
                conn = ConfigurationManager.ConnectionStrings["connectionString1"].ConnectionString;
            }
        
       //  TODO: Add constructor logic here
        
      con = new SqlConnection(conn);
    }

and login class code :-

C#

public class Login
{
	public Login()
	{
	}
 
    public string isLogin()
    {
       
      Connection clsConn= new Connection("2");
       SqlCommand cmd = new SqlCommand("login", clsConn );
    }
}

here i am not access clsconn in sqlcommand so anyone tell me how can i access ??? please

Posted 15-Jan-15 23:16pm

J{0}Y

Updated 15-Jan-15 23:19pm

CHill60

v3

Add a Solution

Comments

CHill60 16-Jan-15 5:20am

What do you mean by no access - what is the actual error message?

J{0}Y 16-Jan-15 6:15am

the best overloaded method match for 'System.Data.SqlCommand.SqlCommand(string, System.Data.SqlClient.SqlClient)' has some invalid arguments

3 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)

TheRealSteveJudge · Accepted Answer · 2015-01-15T23:25:00

http://msdn.microsoft.com/en-us/library/877h0y3a(v=vs.110).aspx[^]
says about SqlCommand Constructor:

VB

public SqlCommand(
    string cmdText,
    SqlConnection connection
)

Therefore second constructor parameter must be an object of SqlConnection class.

But your second constructor parameter is an object of a completely different class.

This cannot work!

You must change your code like this:

C#

SqlCommand cmd = new SqlCommand("login", clsConn.con);

Make sure that con is public.

C#

public SqlConnection con;

DamithSL · Accepted Answer · 2015-01-15T23:26:00

change your Connection class to get connection as below

C#

public class Connection
{
   
    public static SqlConnection  GetConnection( string val)
    {    string conn ="";
        if (val == "1")
        {
            conn = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
        }
        else if (val == "2")
            {
                conn = ConfigurationManager.ConnectionStrings["connectionString1"].ConnectionString;
            }
        
      return new SqlConnection(conn);
    }
}

then you can do as below in other classes

C#

public string isLogin()
   {

      SqlConnection clsConn= Connection.GetConnection("2");
      SqlCommand cmd = new SqlCommand("login", clsConn);
   }

Sinisa Hajnal · Accepted Answer · 2015-01-15T23:29:00

I think you need

SqlCommand cmd = new SqlCommand("login", clsConn.con );

Since your Connection does not inherit from sqlConnection, you have to get the connection object from your Connectio class.

I would suggest you make public property Connection instead of accessing the variable directly.

If this helps please take time to accept the solution. Thank you.

how to access connection string from one class file to another class file

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0