|
No, you should be using LINQ, but short of that, there is nothing wrong with parametrised inline SQL.
|
|
|
|
|
A hearty debate but the general consensus is to use stored procs for a number of benefits.
only two letters away from being an asset
|
|
|
|
|
|
string sql = @"
select *
From Status
From ActivityStatus ActStsId=StsId";
Putting an @ in front of a string makes it a multi-line string. Whitespace is preserved (including newlines). If you had a quote character in your SQL, you'd have to escape it by typing a two of them (you could do this with a quick find-replace in Notepad before pasting into C#).
But like others have said, typically a bad idea to put SQL in C# code. Some environments don't have stored procedures (like SQL Server CE), in which case I'd recommend storing the SQL in your settings as a string setting. You can then reference it by the setting name in your code.
Visual Studio is an excellent GUIIDE.
|
|
|
|
|
aspdotnetdev wrote: Putting an @ in front of a string makes it a multi-line string.
Thank you, I rarely use sql strings and when I do it is a PITA adding in the white space formatting that makes it easier to debug. Learn something every day.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I'm trying to compile my project but its giving me this error:
1. The namespace 'PenDriveBackupProgram' already contains a definition for 'PenDriveBackup'
Prior to this error I was trying to get this class working in my project:
http://downloads.cfdan.com/csharp/us...lnumber.cs.txt
I was calling the class like so:
USBDriveSerialNumber.USBSerialNumber usb = new USBDriveSerialNumber.USBSerialNumber();
string serial = usb.getSerialNumberFromDriveLetter(path);
MessageBox.Show(serial);
But now there is an error in the class which is appearing at runtime?
The error is with this bit of code;
ManagementObjectSearcher searcher1 = new ManagementObjectSearcher("SELECT * FROM Win32_LogicalDiskToPartition");
foreach (ManagementObject dm in searcher1.Get())
And the error is:
Context 0x33c3ff0 is disconnected. No proxy will be used to service the request on the COM component. This may cause corruption or data loss. To avoid this problem, please ensure that all contexts/apartments stay alive until the application is completely done with the RuntimeCallableWrappers that represent COM components that live inside them.
I read some information at MSDN about the project needing full trust, so I went into the project settings -> security -> Enabled ClickOnce Security Settings -> Selected This is a full trust application.
Although I set the global settings to Full Trust the class has the modifer Partial so I figured this could be a problem (First project in C#)
So I removed the partial modifier with everything to do with the PenDriveBackup class which now results in the error you see above.
All help is appreciated greatly, cheers, George.
|
|
|
|
|
Hi,
there seem to be a couple of issues.
the PenDriveBackup error means you have more than one type of that name; that could be classes, structs, enums, etc. Or even two copies of the same code (did you recently copy/paste PenDriveBackup code?).
the Context disconnected error is a run-time error (I don't get how you could get it as you are getting the previous error at compile time, so your app can't run). Are you using threads, and/or doing things regarding AppartmentState? You're not the first today having this problem, I personally never have seen it happen. It could be a COM component referring to a managed object that is no longer around.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? 59.24% waren verstandig genoeg om NEEN te stemmen; bye bye viaduct.
|
|
|
|
|
Firstly thanks for your reply Luc, I appreciate it. Now, there must of been some confusion, I guess I didnt state it correctly.
The COM error that I showed here is an error I got when my code was (apparently working, besides that run-time error) and I seeked online for suggestions on possible solutions and I came across that the program needs Full Trust for it to work. So I changed the project to full trust in project settings and yet the error still persisted. I was able to run the program at this point.
I was then stumped, had no idea what to do until I saw that my main class 'PenDriveBackup' (which resides in Main.cs) had the modifiers 'public partial'.
So the class looked like 'public partial PenDriveBackup : Form'. I removed the partial from the class and went into my Main.Designer.cs where I removed the partial from that class too which then went from 'public partial class PenDriveBackup' to 'public class PenDriveBackup'.
Upon doing this the error, "Error1 The namespace 'PenDriveBackupProgram' already contains a definition for 'PenDriveBackup'" occurs unabling me to compile and that is the current state im in.
My project consists of five items;
Main.cs -> Where most of my code sits.
MessageBoxForm.cs -> Custom message form, used to determine either incremental or full backup.
InputBoxForm.cs -> Custom input box, used to determine where the user wants to backup.
USBSerialNumber.cs -> A class file downloaded from the internet.
And ofcourse, Program.cs
Using the Find function I managed to see which items included the class PenDriveBackup.
Main.cs -> One class, being PenDriveBackup
-> Main.Designer.cs -> A class in here is called PenDriveBackup but as it belongs to Main.cs it can't be the problem?
MessageBoxForm.cs -> Found no class called PenDriveBackup
InputBoxForm.cs ->; Found no class called PenDriveBackup
USBSerialNumber.cs ->; Found no class called PenDriveBackup
I hope I have provided suffecient information to help you, I have been tearing my hair out for the last few days.
Oh and something that may help, if I were to build the USBSerialNumber.cs form in its own project it works. Thats why I thought the modifier partial was causing the problem.
Thanks again Luc!
|
|
|
|
|
OK
1. initially a C# class had to reside in a single file; which also meant Visual Designer, which actually generates code, was modifying your form's C# source file. Then they introduced the notion of partial classes, which means you add the partial keyword to a class, and now can split the class over several files. Since then, Visual Designer has its myForm.Designer.cs file which you shouldn't touch, and you have your myForm.cs file which VD won't touch; they both contain a "public partial class myForm" statement, and the compiler understands the two or more parts have to be joined together to create one class. When you remove the "partial" keywords, that no longer works; the compiler now sees two different classes with the same name, and rightfully complains. You have to reinstate the partials.
2. I don't know about your original problem; I'm not inclined to go with the "full trust" issue.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? 59.24% waren verstandig genoeg om NEEN te stemmen; bye bye viaduct.
|
|
|
|
|
FWIW: Here[^] is the thread mentioning a context problem I read earlier.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? 59.24% waren verstandig genoeg om NEEN te stemmen; bye bye viaduct.
|
|
|
|
|
Thanks once again for your Reply Luc.
I have now fixed the code in regards to the partial modifier and I understand how that works now. I can compile my project yet the runtime error still persists ofcourse.
Looking at the link you gave me it looks as though the problem is something related to a thread however I do not explicity state any threads in my project thus im confident when I say no threads are being used.
In regards to the AppartmentState I also am not using this.
Thanks George.
|
|
|
|
|
i hear that there 's classes for replication in vs 2008
i need that classes and simple example for it
becuase iam in case which can't replicate direct from sql server
i need help
thanks
md_refay
|
|
|
|
|
Hello,
I'm developing my own custom control that is essentially a form with a custom scroll bar, with several command buttons at the bottom of it that will modify the contents of the form. However, when you click these command buttons, it needs to run a sql query which may be slow. Thus I would like some sort of loading screen while it performs the queries and updates the form content. How would I go about doing this? Thanks!
|
|
|
|
|
It's simple, display a messagebox 
only two letters away from being an asset
|
|
|
|
|
Do the query in its own thread?
|
|
|
|
|
And how does this answer the question of how to display a loading dialog ?
only two letters away from being an asset
|
|
|
|
|
I would like one of those ajax like spinning icons in a modal window on top of the panel. How is this possible?
|
|
|
|
|
There is nothing particularly difficult here. Create a dialog with the animated gif, display it modally.
only two letters away from being an asset
|
|
|
|
|
Dear Sirs,
I have used Netbeans and Eclipse IDEs, and they have a nifty feature such that while you're typing a string literal, you can press enter, and it automatically inserts end quotes, plus sign, the appropriate tabs, then beginning quotes so that if I type
if (flag)
string str = "There was an error in the output, you must first [enter]type 't', then the input.";
, the output is thus:
if (flag)
string str = "There was an error in the output, you must first " +
"type 't', then the input";
Is there an analogous feature in Visual Studio. Now, I have to type the end-quotes, the plus sign, enter, and the beginning quotes, and it gives me the red-squiggly the whole time.
Thanks for your responses.
In Christ,
Aaron Laws
http://ProCure.com/
|
|
|
|
|
Hi,
no, I don't think there is.
FWIW: your example doesn't make sense, str is unused and out of scope right away.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? 59.24% waren verstandig genoeg om NEEN te stemmen; bye bye viaduct.
|
|
|
|
|
Dear Mr. Pattyn,
Yeah, you HAVE to put things like this in your code all over the place, so that you can put out another version in a few months which is `optimized.' You must be novice. 
In Christ,
Aaron Laws
|
|
|
|
|
No, he's no novice. What he commented on was your example. You declared a variable in the True side of teh if statement and didn't use it for anything.
He knows full well that the quotes and + sign is required as described in your question. No, there is no equivilent in Visual Studio. But, it sounds like a perfect opportunity for you to create a plugin to do it.
|
|
|
|
|
LimitedAtonement wrote: You must be novice
Yes I'm learning new stuff every day. 
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? 59.24% waren verstandig genoeg om NEEN te stemmen; bye bye viaduct.
|
|
|
|
|
Dear Sirs,
Oh!! I was wondering why my message didn't seem to hit its mark properly -- I meant to put a wink in there after `novice'!! I'm just kidding! Now I see that the wink was edited out...how do I get a little smiley face in the text? Sorry if this was taken wrong.
In Christ,
Aaron Laws
http://ProCure.com
|
|
|
|
|
Hello Everyone, I am trying to add some components with my App. What it should do is during installation the App should ask user to create userName, password,and put the organization name that will use this App.
Since this is for the first time I am trying to deploy a project I do not have much knowledge about it. If some one be kind enough to help me that will be great.
Thaks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
