how to make global declarations

Question

1.00/5 (1 vote)

See more:

C#

SqlConnection con = new SqlConnection(@"DataSource=.\SQLEXPRESS;AttachDbFilename=E:\prashantcs\crm111\CRM111.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");

I have the code shown above.I am declaring it again and again for each and every page
The reason why i am asking this is i need to install it different desktops so every time i am changing the path for all the pages so that it takes that particular computers path and name.ill change it but only once if i declare it globally.

Is there any method for declaring it globally.

plz help me..

Posted 11-Dec-11 20:20pm

Member 8388026

Updated 11-Dec-11 20:22pm

Karthik Harve

v2

Add a Solution

Comments

Karthik Harve 12-Dec-11 2:22am

added pre tags.

2 solutions

Solution 1

if all the desktops or PCs are in Network then you can create a network drive in one of the PCs and copy the mdf file in that shared drive. so that all the systems can access the file from that network path.

see here for more on netwrok drives..

http://support.microsoft.com/kb/308582[^]

http://compnetworking.about.com/od/windowsxpnetworking/ht/mapnetworkdrive.htm[^]

and specify that network path in your connection string.

hope it works..

Posted 11-Dec-11 20:33pm

Karthik Harve

Comments

Member 8388026 12-Dec-11 2:36am

no they are not in one network

Member 8388026 12-Dec-11 2:38am

they are not in one network but different place

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)

uspatel · Accepted Answer · 2011-12-11T20:41:00

you can add a class and make method like

C#

public class Db
{
	public Db()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    public static SqlConnection GetConnection()
    {
        SqlConnection cn = new SqlConnection();
       // cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cnn"].ToString();
cn.ConnectionString=@"DataSource=.\SQLEXPRESS;AttachDbFilename=E:\prashantcs\crm111\CRM111.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
        cn.Open();
        return cn;
    }
}

use this method as

C#

SqlCommand cmd12111 = new SqlCommand();
           cmd12111.CommandText = "insert_File_Request1";
           cmd12111.CommandType = CommandType.StoredProcedure;
           cmd12111.Connection = Db.GetConnection();//Db class method
           cmd12111.Parameters.AddWithValue("ReqControlNo", ReqControlNo);
           cmd12111.Parameters.AddWithValue("ReqDate", ReqDate);
           cmd12111.Parameters.AddWithValue("ReqTime", ReqTime);
           cmd12111.ExecuteNonQuery();
           cmd12111.Connection.Close();

hope it will helps you.