C#

FirstPrevNext

connection string in a file Adekolurejo19-Jun-09 3:38 Adekolurejo 19-Jun-09 3:38  Please I need help on this problem. I have an application am writing using visual c# 2008. The isuse is this I want connection string to the database to be read from a file save elsewhere on the system because after package and installation of the application if there is any changes in the connection parameter i will just change it in the file insted of changing it in the code and package it again. Onformload, he read the connection file and connect to database. Thanks Ademola Re: connection string in a file SeMartens19-Jun-09 3:44 SeMartens 19-Jun-09 3:44  Did you ever heard of the App.config? Click on your project in VS, select "Add new element" and choose "application settings file" from the dialog. You can access the config with System.Configuration.ConfigurationManager.ConnectionStrings. Have a look here: http://www.ezzylearning.com/tutorial.aspx?tid=8067328[^] Regards Sebastian It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland. Re: connection string in a file stancrm19-Jun-09 3:47 stancrm 19-Jun-09 3:47  And the question ist ?? I think, what you need is how to write the connection string to a file, is that write ? When yes, then use : string connectionString = "...abc..."; File.WriteAllText(@"c:\myfile.txt", connectionString); string connectionString = File.ReadAllText(@"c:\myfile.txt"); You must also encrypt your connection string before write it to a file. You don't want anybody to know your database password, do you ?.. Re: connection string in a file harold aptroot19-Jun-09 4:00 harold aptroot 19-Jun-09 4:00  stancrm wrote: You must also encrypt your connection string before write it to a file. You don't want anybody to know your database password, do you You can't make it impossible. If you encrypt it, well, your program would contain the code to decrypt it. And they will have that code. The same problem applies to all local data and is impossible to solve, though you could make the chain of encrypted keys of arbitrary length to slow the attacker down. Edit (used to be something here about encrypted connection strings): scratch that, it's just impossible as well. Great. So now we know you don't even need to try to hide your connection string, at least that saves us all some effort. Re: connection string in a file Adekolurejo19-Jun-09 4:30 Adekolurejo 19-Jun-09 4:30  File.WriteAllText(@"c:\myfile.txt", connectionString); string connectionString = File.ReadAllText(@"c:\myfile.txt"); thanks but File will be declare as what in this context? Re: connection string in a file harold aptroot19-Jun-09 4:34 harold aptroot 19-Jun-09 4:34  You don't declare File, it already exists. Re: connection string in a file meeram39519-Jun-09 3:48 meeram395 19-Jun-09 3:48  Probably this may help you. Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration. Re: connection string in a file [modified] kstls20-Jun-09 11:03 kstls 20-Jun-09 11:03  I would use App.config aswell as SeMartens describes, but if you prefer to use a seperate file other than App.config, why not make the main program retrieve the connectionstring from a seperate class with a static method and just have that as a dll file. Then if the connectionstring should change you only have to replace the dll with a new one. modified on Saturday, June 20, 2009 5:15 PM Urgent Mail Sending Problem dev sheoran19-Jun-09 2:09 dev sheoran 19-Jun-09 2:09  Hi, I am sending emails with attachment(.txt file) using c#. I read data from database saved as varchar datatype. I read data in memory stream and output the memory stream as attachment with content type text(.txt file). It sends emails to gmail, yahoo,hotmail,rediff etc. mail servers with attachment(which is a .txt file) perfectly fine. (It means there is no problem with code) But when i send emails to my own mail server it skips the attachment i.e. i get the emails without attachment. Please help me asap. What could be the reason? My mail server IP is 72.9.144.139 Thanks, Dev Re: Urgent Mail Sending Problem Not Active19-Jun-09 2:13 Not Active 19-Jun-09 2:13  1) Don't mark your post as Urgent, it's rude and will not get any attention from those who could best help 2) Don't include your server IP address on a public forum. Unless you want your mail server to be used for sending spam. Could it be that your server is blocking the attachments? only two letters away from being an asset Re: Urgent Mail Sending Problem dev sheoran19-Jun-09 2:30 dev sheoran 19-Jun-09 2:30  Thanks for your precious suggestions. We use to send emails with attachment to and from our mail server. We get emails with attachment from other mail servers also. I don't think that our server is blocking attachment. Re: Urgent Mail Sending Problem Nagy Vilmos19-Jun-09 3:22 Nagy Vilmos 19-Jun-09 3:22  You thank for help and yet leave the ip address. Interesting. Panic, Chaos, Destruction. My work here is done. Re: Urgent Mail Sending Problem [modified] musefan19-Jun-09 3:24 musefan 19-Jun-09 3:24  The edit button is commonly overlooked by new CP members SEE THIS IS AN EDIT: Now all he needs to do is edit his OP and remove IP Address: [REMOVED] so no one can see it... Oops Life goes very fast. Tomorrow, today is already yesterday. modified on Friday, June 19, 2009 9:38 AM Re: Urgent Mail Sending Problem EliottA19-Jun-09 3:38 EliottA 19-Jun-09 3:38  Why make it worse by highlighting the fact he left his mail server IP address, not that it's anything important or useful to the outside world, it can be resolved with a DNS request. But either way, why repeat it and take attention to his error? Check out the CodeProject forum Guidelines[^] The original soapbox 1.0 is back![^] Re: Urgent Mail Sending Problem musefan19-Jun-09 3:40 musefan 19-Jun-09 3:40  I'm just playing with him, and if the error was not pointed out then how would he know not to do it in the future? Life goes very fast. Tomorrow, today is already yesterday. Re: Urgent Mail Sending Problem musefan19-Jun-09 2:39 musefan 19-Jun-09 2:39  dev sheoran wrote: (It means there is no problem with code) So why are you posting in a programming forum? Sounds like some setup on your server. Anyway, thanks for the IP address. I'm sure I could have some fun with that Life goes very fast. Tomorrow, today is already yesterday. How to transfer data without using dataset Ersan Ercek19-Jun-09 1:53 Ersan Ercek 19-Jun-09 1:53  Hi, I just started to work for a retail company where I am supposed to handle large databases. I need to transfer data from AS400 to MS Access where I will use for reporting purposes. When I use dataset I receive memory exception. Is it possible to transfer data directly without using dataset(means without using virtual memory). Thanks in advance Re: How to transfer data without using dataset Not Active19-Jun-09 2:10 Not Active 19-Jun-09 2:10  Why would they want to transfer the data to Access Do they realize there are reporting solutions that will work without the transfer. Or at least use SQL Server, Express is free and coupled with SSRS it would be better than Access, IMHO You could do it with a datareader, transfer one record at a time. only two letters away from being an asset Re: How to transfer data without using dataset SilimSayo19-Jun-09 2:16 SilimSayo 19-Jun-09 2:16  Access can be a very good reporting tool but the problem with many Access users is that they tend to want to import the data into access and then report on it. Instead, you should create linked tables in access and then create parameterised queries on which to base the reports. Doing so will ensure that only the data you're reporting on gets copied temporarily into access Re: How to transfer data without using dataset Not Active19-Jun-09 2:35 Not Active 19-Jun-09 2:35  Why respond to my answer, respond to the original post only two letters away from being an asset Re: How to transfer data without using dataset Ersan Ercek19-Jun-09 4:31 Ersan Ercek 19-Jun-09 4:31  Thank you both, For sql Server Suggestion; No way, they would not consider purchasing it. Access, I will create one table that has links to different tables, since the data I am going to use is huge for Access. Re: How to transfer data without using dataset Not Active19-Jun-09 5:06 Not Active 19-Jun-09 5:06  SQL Server Express is FREE. Advanced includes SSRS also. You would be setting the company up with better tools and positioning them for better migration. The tools are FREE, only costs a little time to download and install. Rather than having individual copies of Access databases floating around it could be centralized. Better management, more accurate reporting. IMHO only two letters away from being an asset Re: How to transfer data without using dataset Ersan Ercek24-Jun-09 5:37 Ersan Ercek 24-Jun-09 5:37  Thank you again. I will suggest them. All the best. EventLog logging with log4net Jammer19-Jun-09 1:08 Jammer 19-Jun-09 1:08  Hi All, I've been poking around Google / Apache.org trying to get to the bottom of this with no luck. There isn't a lot of info anywhere on configuring log4net using pure C# so I thought I'd try here now. I can log to the "Application" log with no problems. I can also create "MyLog" event log without problems as well, however, writing to "MyLog" fails to actually write an event log entry. The code I'm using to configure an EventLogAppener is: public static void ConfigureEventLogAppender(string appName, string logName) { PatternLayout layout = GetDefaultLayout(); _eventLogAppender = new EventLogAppender(); _eventLogAppender.ApplicationName = appName; _eventLogAppender.Layout = layout; _eventLogAppender.LogName = logName; _eventLogAppender.Threshold = Level.All; _eventLogAppender.ActivateOptions(); BasicConfigurator.Configure(_eventLogAppender); } Has anyone managed to get this working? Cheers, Jammer My Blog | Article(s) Check system date when form load KIDYA19-Jun-09 1:03 KIDYA 19-Jun-09 1:03  Hello Experts!! i want to check system date and my date so i can avoid date mismatch. when my date is greater than system date then it must give date mismatch error. I am using it for checking my project expiry date......if anybody have another way then free to tell me....... Is anybody have code for it????

Last Visit: 31-Dec-99 18:00     Last Update: 24-Jun-24 18:52 Refresh ᐊ Prev1...4852485348544855485648574858485948604861 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.