C# Discussion Boards - CodeProject

Mycroft Holmes10-Nov-12 13:21

10-Nov-12 13:21

ASPnoob wrote:
with the sealed modifier

You missed this in your understanding, sealed means, well sealed!

Never underestimate the power of human stupidity
RAH

Alan N10-Nov-12 13:27

Alan N

10-Nov-12 13:27

MSDN isn't always right and sometimes, like here, they don't update the documentation. If you follow the 'other versions' links, at the top of that page, to VS 2012, you'll see that the stuff about 'abstract sealed' has been changed.

It's possible that the person who wrote the docs was confusing C# and intermediate language (IL) classes. When a C# static class is compiled to IL, the class declaration is marked as abstract and sealed. So a C# static class is equivalent to an IL abstract sealed class.

In C# it's not actually possible to declare a class as 'abstract sealed'. Try it and you'll find that it won't compile.

Alan.

ASPnoob10-Nov-12 14:24

ASPnoob

10-Nov-12 14:24

Thank you all for responding. I guess the confusion was over the fact that the author of the article was not being very clear.

C# issue: connection string to app.config file

Richard Deeming12-Nov-12 2:09

Richard Deeming

12-Nov-12 2:09

I agree that this sentence could be clearer. What they're trying to say is:

You cannot add the sealed modifier to an abstract class;
The sealed modifier means that a class cannot be inherited;

It looks like they cleared this up in the VS2010 version[^], where the sentence has been changed to:

It is not possible to modify an abstract class with the sealed (C# Reference) modifier because the two modifers have opposite meanings. The sealed modifier prevents a class from being inherited and the abstract modifier requires a class to be inherited.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

rachel_m10-Nov-12 8:05

rachel_m

10-Nov-12 8:05

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.

Re: C# issue: connection string to app.config file

Eddy Vluggen10-Nov-12 23:38

Eddy Vluggen

10-Nov-12 23:38

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.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

Re: C# issue: connection string to app.config file

rachel_m11-Nov-12 6:11

rachel_m

11-Nov-12 6:11

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.

Re: C# issue: connection string to app.config file

jschell11-Nov-12 10:39

jschell

11-Nov-12 10:39

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.

SSRS: How to deploy RDLC files with visual-studio 2010 setup

Tridip Bhattacharjee10-Nov-12 7:49

Re: SSRS: How to deploy RDLC files with visual-studio 2010 setup

10-Nov-12 7:49

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

Mycroft Holmes10-Nov-12 13:17

Re: SSRS: How to deploy RDLC files with visual-studio 2010 setup

10-Nov-12 13:17

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

Tridip Bhattacharjee11-Nov-12 6:57

Re: SSRS: How to deploy RDLC files with visual-studio 2010 setup

11-Nov-12 6:57

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

Mycroft Holmes11-Nov-12 11:39

Re: SSRS: How to deploy RDLC files with visual-studio 2010 setup

11-Nov-12 11:39

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

Tridip Bhattacharjee11-Nov-12 19:35

Re: SSRS: How to deploy RDLC files with visual-studio 2010 setup

11-Nov-12 19:35

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

Mycroft Holmes11-Nov-12 21:29

Re: SSRS: How to deploy RDLC files with visual-studio 2010 setup

11-Nov-12 21:29

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

Tridip Bhattacharjee13-Nov-12 19:53

Export data from report to excel in the wrong format

13-Nov-12 19:53

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

nhanlaptrinh9-Nov-12 19:29

nhanlaptrinh

9-Nov-12 19:29

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.

Re: Export data from report to excel in the wrong format

Eddy Vluggen10-Nov-12 7:22

Eddy Vluggen

10-Nov-12 7:22

The links to the pictures do not work for me.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

Re: Export data from report to excel in the wrong format

Mycroft Holmes10-Nov-12 13:11

ExplorerBand,Explorer extending,I want to add a bar to the WindowsExplorer(not IE).

10-Nov-12 13:11

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

ohsorry9-Nov-12 16:05

ohsorry

9-Nov-12 16:05

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!

Direct Sound

Michael Kurdík9-Nov-12 7:41

Michael Kurdík

9-Nov-12 7:41

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.

Re: Direct Sound

Mycroft Holmes10-Nov-12 13:05