|
In a C# 2008 application, I used linq to sql to connect to a sql server 2008 database. Now I want to obtain the connection of the database from the
app.config file instead of hardcoding the value into the application. I want to be able to change the connection string to the database since I will be moving this application from unit testing database to user acceptance database to the the prodction database.
Right now I am getting the error message, ""Object reference not set to an instance of an object." I know this error message is coming from the line of code that I listed below since it is the only line of code I changed.
The following is a snippet of the code from the *.designer.cs file (this is part of the dbml file).
using System.Configuration;
public esampleDataContext() :
base(ConfigurationManager.ConnectionStrings["sample.Properties.Settings.DEVConnectionString"].ConnectionString,mappingSource)
**Note: base(global::sample.Properties.Settings.Default.DEVConnectionString, mappingSource) is the line of code that I replaced that was generated by the
.net framework
I want to mention the following:
1. The *.dbml file is associated with a particular project file.
2. The connection string settings for this *.dbml file are the following:
a. DEVConnectionString (settings)
b. Connection String = Data Source=dev1;Initial Catalog=DEV_test;Integrated Security=True
c. application settings=True
d. settings property name is DEVConnectionString.
3. The project file that has the *.dbml file. has a reference set to the system.configuration.
**Note: This code in similar applications that I wrote, but I do not why it does not work here.
Thus can you tell me, show me in code, and/or point me to a reference that I can use so I can obtain the value in the app.config file for the database connection string I want to use. I do not want to use a hard-coded connection string to the database.
|
|
|
|
|
rachel_m wrote: point me to a reference that I can use so I can obtain the value in the app.config file for the database connection string I want to use. I do not want to use a hard-coded connection string to the database.
Correct me if I'm wrong, but isn't the connectionstring in the app.config file? Isn't the app.config file an XML file that can be edited?
If both answers are yes, then your connectionstring isn't hardcoded, but loaded from the settings-file.
|
|
|
|
|
The problem is the settings-file does not get the value from the app.config file. The values are retained in the settings-file from the time I orginally created the app.config file. The settings-file needs to change at some point.
|
|
|
|
|
rachel_m wrote: ConfigurationManager.ConnectionStrings
Your app.config needs to be set up in a very specific way for that to work.
If it isn't set up that way then ConnectionStrings will be null.
I would suggest that you do the following
1. Create a project/app that ONLY gets the connection string
2. Create a app.config that ONLY has that connection string.
3. Verify in that app that ConnectionStrings is not null before using it.
4. Get the connection string property and print it.
Then if that doesn't work then you can post the entire class and the entire app.config. Do not include real info in the app.config all you care about is that it get a value not what is in it.
|
|
|
|
|
i am developing a win apps where many .rdlc are there in report folder of that project. when i will create a setup for delivery to client then do i need to include all those .rdlc file manually or it will be included automatically like .rpt (crystal report) files.
what i can do as a result always .rdlc files will be automatically included when i will batch build of my project. anyone can guide me. thanks
tbhattacharjee
|
|
|
|
|
I found that reports tend to grow, usually AFTER the application has been deployed and has been used for some time. Also if you have different customers they often want distinct reports.
I had all my reports in a table, all records had a stored procedure name and a file name, if the file existed and the procedure existed the report could execute.
I could then distribute a new report without having to recompile and distribute the app. Simple deliver the file and a script to create the stored procedure and report record.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
i understand that you are talking about RDL report which is stored in sql server database but here i asked about RDLC which is client side.i asked how could i distribute my rdlc files with my application setup as a result when client install my setup then he can view the report which is based on rdlc. i like to know what is industry standard way to include rdlc into setup project. if you such thing then please advise. thanks
tbhattacharjee
|
|
|
|
|
No I was talking about a strategy for distributing RDLC reports. You can include the reports in a folder in your setup project. I don't believe there is an 'industry standard' as most installer tool work differently.
I find that the reporting requirement changes as the user gets familiar with the application and additional reports are always needed AFTER delivering the application.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
i know it is possible that we can create a folder and include report manually every time before building setup but i want to know is there any automated process by which report will be added automatically every time when we build setup from a particular folder. let me know.thanks
tbhattacharjee
|
|
|
|
|
I'm not up with winforms deployment as I'm using Silverlight but I would have thought that once you have completed a reports development and testing that you move it to a deployment folder and include that folder in the deployment build!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
if u work with VS2010 IDE then you wont find a way to include any folder into setup project. if u know any trick then please share with me. thanks
tbhattacharjee
|
|
|
|
|
I am using Visual 2010 and sap crystal report 2010. When displayed on the report is correct, but when exported to excel from report tool does not display properly.Have you asked yourself how to fix it. Thanks!
http://ns5.upanh.com/b2.s33.d4/a441d8c1b7a11d88b97ab705853a5aa7_50724625.untitled2.png
http://ns0.upanh.com/b5.s35.d2/f46ed5f91e34dcf07484926270a1e888_50724660.untitled4.png"
modified 10-Nov-12 14:22pm.
|
|
|
|
|
The links to the pictures do not work for me.
|
|
|
|
|
I doubt you will get a reasonable response for this issue, Crystal Reports is a dog, their support is legendary, and critically the export methods are a black box, IE you cannot control or adjust it!
We found in SSRS that aligning columns and objects with absolute precision eliminated a lot of superfluous formatting in Excel.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Sorry, my English sucks, I hope I can express clearly.i want to add a bar to the windows explorer,after a long time searching,i'v made a bar using BandObjectsLib(a C# library) and added it in to the Explorer window.but i have to open it through "Menu-View-Explorer bar",and the bar also came out in IE :<.my question is how to make it opened automaticly when Windows Explorer is opend.Or any other way to do this,i want to add a big horizontal bar actually a region in the bottom (or somewhere else) of Windows Explorer,so i can put my code and usercontrols into it.i use C#,vs2012,windows 7.thank you!
|
|
|
|
|
Hi, everybody.
My app uses a tablist and on each tab is option for replaying and rendering WAV file. One file is for one tab and another file for another tab, and so on.
My solution is folowing : WAV file is loaded in byte array for fast plotting and this array is common for all of tabs. When it will switch tab to another tab, data in array going to change according file for tab. For replay is used SecondBuffer of DirectSound. When are data loaded to SecondBuffer from array of bytes, allocated memory on PC increases... Is any option, how to release memory from SecondBuffer after playing? Or... If have anybody some other solution for WAV playing?
Thank you very much.
|
|
|
|
|
I'm not going to be of any help here, I have such a negative reaction to noisy applications (other than games) that I rarely even look for an option to silence them, I simply kill the page or uninstall the app! Please, please give the user the option to silence your app unless it is an integral part of your solution (a sound on a tab does not seem to qualify for integral!).
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I solved it so, that I have small SeccondaryBuffer (size is much smaller than size of replaying WAV) and SeccondaryBuffer is in loop. Paralel Timer writes new data in to small SeccondaryBuffer from large byte array of WAV.
|
|
|
|
|
I created a new WinForms project and got this error:
The designer could not be shown for this file because none of the classes within it can be designed.
I have not yet added any code to the project. It appears as if all of the necessary assemblies are referenced, but intellisense can't seem to resolve the Form class.
EDIT ---------------------
Shutting VS2012 down and starting it back up again solved the issue. Weird.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997
modified 9-Nov-12 12:34pm.
|
|
|
|
|
And most certainly there is an implicit question hidden in that post somewhere.
If I could only make it out.
Hmmmmmm ...
"I had the right to remain silent, but I didn't have the ability!"
Ron White, Comedian
|
|
|
|
|
I'm a asp.net beginner I want to sharp my C# skills. It will be a great help, if any one can suggest me a project, so that while developing the same I can enhance my C# skills.
Thanks in advance.
|
|
|
|
|
Here is one that I recently did as a convert to C#: Football Club Competition/Fixture Management in WPF and MVVM. (Extra points for rolling your own re-usable MVVM Project framework)
I don't speak Idiot - please talk slowly and clearly
"I have sexdaily. I mean dyslexia. Fcuk!"
Driven to the arms of Heineken by the wife
|
|
|
|
|
No idea why this got downvoted. Ive 5'd for balance.
|
|
|
|
|
I thank you Sir.
Maybe the fact that I mentioned WPF when the OP was looking for ASP.NET was the reason. I don't see how my answer was wrong in that context as you could esily substitute the WPF front end with a ASP.NET version (or have both, and....).
Sheesh.
I don't speak Idiot - please talk slowly and clearly
"I have sexdaily. I mean dyslexia. Fcuk!"
Driven to the arms of Heineken by the wife
|
|
|
|
|
If you dont even have the imagination to think up a basic project, there is no way in the world youre going to have the imagination to design and write it.
Give up now.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
