connection string Web.config + ASP.net C#
-
what ?
-
Hi every one. I have copying my database via setup to Program File of customer system. now how can i give the conection string that can attach the DB (in webconfig):
I have used "
%ProgramFiles%" but no use... Please Help Thanks in Advanced !If you use values like this in your connection string then i think you will need to modify it at execution time in order to replace the
%programfiles%with the real path. See Web.config File - ASP.NET[^] for some useful information on the web.config file.One of these days I'm going to think of a really clever signature.
-
If you use values like this in your connection string then i think you will need to modify it at execution time in order to replace the
%programfiles%with the real path. See Web.config File - ASP.NET[^] for some useful information on the web.config file.One of these days I'm going to think of a really clever signature.
Thanks for solution but i didnt get anything..plz give an example how to do that. Thanks in advanced
-
Thanks for solution but i didnt get anything..plz give an example how to do that. Thanks in advanced
You need to spend some time getting familiar with MSDN, which contains documentation for just about everything you will ever need, including this section on environment variables[^].
One of these days I'm going to think of a really clever signature.
-
Thanks for solution but i didnt get anything..plz give an example how to do that. Thanks in advanced
-
Why have you created a new CodeProject id for this?
One of these days I'm going to think of a really clever signature.
It was mistake that i create two id... How can i use Environment.ExpandEnvironmentVariables in web.config for connectionstring? Thanks in advanced!
-
It was mistake that i create two id... How can i use Environment.ExpandEnvironmentVariables in web.config for connectionstring? Thanks in advanced!
Member 9473809 wrote:
It was mistake that i create two id...
Then please post a message here[^] to ask the administrators to remove the duplicate.
Member 9473809 wrote:
How can i use Environment.ExpandEnvironmentVariables
The link to the documentation that I posted contains a code sample, I cannot offer anything that is clearer than that.
One of these days I'm going to think of a really clever signature.
-
Member 9473809 wrote:
It was mistake that i create two id...
Then please post a message here[^] to ask the administrators to remove the duplicate.
Member 9473809 wrote:
How can i use Environment.ExpandEnvironmentVariables
The link to the documentation that I posted contains a code sample, I cannot offer anything that is clearer than that.
One of these days I'm going to think of a really clever signature.
Thanks ! But i didnt find the solution. Isn't there anybody to do that !
-
Thanks ! But i didnt find the solution. Isn't there anybody to do that !
-
You have the solution, it's just that you need to to spend some time modifying it so it suits your specific problem.
One of these days I'm going to think of a really clever signature.
thanks i dont know the solution . Help! if possible give example!
-
thanks i dont know the solution . Help! if possible give example!
jojoba2011 wrote:
i dont know the solution .Help! if possible give example!
There is really no point in you repeatedly posting the same cry. I have given you a link to the method you need to use, which includes a code sample which demonstrates exactly how it can be used to expand an environment variable in a string. Unless you give some more details about how exactly you are trying to use it and why it does not work, then it is unlikely that we can guess what your problem is.
One of these days I'm going to think of a really clever signature.
-
jojoba2011 wrote:
i dont know the solution .Help! if possible give example!
There is really no point in you repeatedly posting the same cry. I have given you a link to the method you need to use, which includes a code sample which demonstrates exactly how it can be used to expand an environment variable in a string. Unless you give some more details about how exactly you are trying to use it and why it does not work, then it is unlikely that we can guess what your problem is.
One of these days I'm going to think of a really clever signature.
Hi sir, this is exactly what i wanna to use in webconfig:
i dont know which drive is system drive (C or D).cause my setup copies the database to %programfiles% . may be C:\program files OR D:\Program files.
-
Hi sir, this is exactly what i wanna to use in webconfig:
i dont know which drive is system drive (C or D).cause my setup copies the database to %programfiles% . may be C:\program files OR D:\Program files.
I still don't understand what your problem is. If you follow the documentation in the link I gave you[^], it shows exactly how to get the real path from an environment variable, including the system drive. What more do you need?
One of these days I'm going to think of a really clever signature.
-
Hi sir, this is exactly what i wanna to use in webconfig:
i dont know which drive is system drive (C or D).cause my setup copies the database to %programfiles% . may be C:\program files OR D:\Program files.
I think this is what your looking for. Your example makes no sense to me, and I don't see the point of it. If your sql server is loaded on your hard drive, why not use the standard connection string? As far as using a programmable path like %ProgramFiles%, that's a Windows thing, which works in certain scripting languages and the cmd prompt. I don't think the application that reads the web.config file is smart enough to translate %ProgramFiles% to the proper file path, and if it did, you need to see if it adds the final slash to the end of the path. You still have to code the database name to make it work. Since it's on your hard drive, a trusted connection should work fine.
Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf;Database=dbname;
Trusted_Connection=Yes;[Edit] If you need connection strings, go here http://www.connectionstrings.com/[^] Richard, I was talking to the OP, still getting use to the new look and feel.
-
I think this is what your looking for. Your example makes no sense to me, and I don't see the point of it. If your sql server is loaded on your hard drive, why not use the standard connection string? As far as using a programmable path like %ProgramFiles%, that's a Windows thing, which works in certain scripting languages and the cmd prompt. I don't think the application that reads the web.config file is smart enough to translate %ProgramFiles% to the proper file path, and if it did, you need to see if it adds the final slash to the end of the path. You still have to code the database name to make it work. Since it's on your hard drive, a trusted connection should work fine.
Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf;Database=dbname;
Trusted_Connection=Yes;[Edit] If you need connection strings, go here http://www.connectionstrings.com/[^] Richard, I was talking to the OP, still getting use to the new look and feel.