|
Wes Aday wrote: Why are you asking this again?
To be fair to the OP, he originally asked this in the lounge. He was advised to post it here. It wasn't his fault that the other post was moved here.
|
|
|
|
|
Pete O'Hanlon wrote: in the lounge
Thanks Pete. I see that now.
Seems that the univoter followed him along.
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
|
|
|
|
|
ya i don't know how to call that connection string into our.cs file EXAMPLE;
SqlConnection con=new SqlConnection ("Conn");
i am getting error in this line,
and in my class file i declared connection string as
string Conn="My Connection String from Database";
|
|
|
|
|
Then do it the way I suggest below. This way you just pick it up when you need it.
|
|
|
|
|
|
Good job. Glad I could help.
|
|
|
|
|
Your question doesn't make much sense. What according to you is a class file and a .cs file? Post your relevant code here so we can see your problem and suggest some solutions.
|
|
|
|
|
A connection string is just a string that conforms to a particular pattern. The actual value that goes into the string depends on how the database is set up (e.g. is it accessed Windows Authentication) and other features such as whether or not you want Multiple Active RecordSets (MARS), which allows you to perform several reads using what appears to be the same connection. A good list of connection strings is available here[^]
It's traditional to store the connection string inside the .config file. There is a ConnectionStrings section (you won't see it in the default .config file, as you have to add it). Inside this ConnectionStrings section, you will add a ConnectionString entry that holds the details of the connection itself.
To retrieve the connection string in your code, you just need to use the following (here I'm assuming you've added your connection string into the config file with a key of MyConnectionString):
string connectionString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
|
|
|
|
|
I think the OP's question has got more to do with accessing a field in one class from another than with connection strings.
|
|
|
|
|
Whaddya know? I was right.
|
|
|
|
|
Pete O'Hanlon wrote: I was right.
No you're still not. He had used
SqlConnection con = new SqlConnection("Conn");
Removing the quotes around Conn would have worked since he had already declared Conn. The actual question has got to do with where he had declared the Conn variable and if his line of code had access to it (which is still not clear from the OP's post).
|
|
|
|
|
Funnily enough, by using the method I described it works for him without any cross class issues. So, what I told him to do was right as his code is now working.
|
|
|
|
|
hi friends i am not a boy ,i am a girl and actually i am very new to C# .In my company there is no one to teach that's why i had these kind of doubts. I searched so many websites but i didn't get proper thing that what i have searched.thanks friends ..
|
|
|
|
|
Member 9259606 wrote: hi friends i am not a boy ,i am a girl
Cool. Well, let me welcome you aboard Code Project (but with a username like that, it's so hard to guess what sex you are).
Don't worry about your posting. Quite often, you'll get answers that answer JUST the question you asked without considering what the alternatives are. In this case, you got both; it just happened that I thought you'd be better off using the in built .NET mechanism, rather than having to manage it yourself.
Anyway, I'm glad that you got the answer you wanted, and don't be afraid to post questions. That's what the forums are for.
|
|
|
|
|
This is the first time i am posting a question and in the first time itself i got negative points .So i was little bit scared to post questions again even though i posted and thanks Pete for appreciating me. 
|
|
|
|
|
Welcome to CodeProject and don't worry about the downvoting. Please feel free to ask as many questions as you want, but remember to state your questions in a clear and easy-to-comprehend manner, preferably with an example and/or code.
|
|
|
|
|
Ignore the downvotes. They don't really count for anything, and don't be scared to post new questions. The more you ask, the more you learn how the forums work and you'll soon get used to it.
|
|
|
|
|
Firstly I would have a look here so that you can construct your connection string[^]
then I can only assume that you are after declaring a string variable that you can use through out your class, so then I would look at this
public class myDatabaseClass
{
private string _ConnectionString = "my database string here";
public void ShowString()
{
Debug.Print(_ConnectionString);
}
}
Myself personally I prefer to use the AppConfig to store such changeable information as its easier to change without having to recompile and distrubite the application again.
I would have a read of this as it will give you a start : Configuring a Connection String in the App.Config File During Runtime in C#[^]
I know it is for Visual Studio 2010 but it will give you the general idea.
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
you can use below code Separete class file
public SqlConnection con;
public SqlTransaction trans;
public SqlConnection CreateConnection()
{
//string strCon = "";
//strCon = System.Configuration.ConfigurationManager.AppSettings.Get("ConnectionString");
con = new SqlConnection(ConnectionString.Conn());
return con;
}
private void OpenConnection()
{
CreateConnection();
con.Open();
}
private void CloseConnection()
{
con.Close();
con.Dispose();
}
public void BeginTransaction()
{
OpenConnection();
trans = con.BeginTransaction(IsolationLevel.ReadUncommitted);
}
public void CommitTransaction()
{
trans.Commit();
//con.BeginTransaction();
trans.Dispose();
CloseConnection();
}
public void RollbackTransaction()
{
trans.Rollback();
trans.Dispose();
CloseConnection();
}
Call Bunn Layer
Connection conn = new Connection();
conn.BeginTransaction();
|
|
|
|
|
i want to create a connection string in class file and i have to use that connection string in my .cs file that is C#.net i m using visual studio 2008 and sqlserver 2005 .. anyone plz post ur ans r example for this
modified 13-Aug-12 9:17am.
|
|
|
|
|
This isn't going to go well for you.
The rules at the top say do not post programming questions here, and...
Member 9259606 wrote: anyone plz post ur ans r example for this
You will not get a response using language like that, use proper words and ask in the Quick Answers section.
Every man can tell how many goats or sheep he possesses, but not how many friends.
Shed Petition[ ^]
|
|
|
|
|
 you just commited blasphemy. You posted a programming question in the lounge and violated about every rule in the book.
Please go to the C# forum and post your question there AFTER reading the guidelines (guidelines are always the first post in each forum, highlighted in yellow)
prepare for some downvoting and flaming, but don't take it personally, just follow the guidelines in the future and you'll be fine.
V.
modified 13-Aug-12 9:14am.
|
|
|
|
|
V. wrote: you just commited balphemy
Balphemist!
|
|
|
|
|
woopsy-daisy 
V.
|
|
|
|
|
sure u can have answer, best 2 stare in space for long time - annswer will cum to u in flash
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
