|
hi, I used the below code in sql and it gave me something like: "Item 3,00" in two columns but how can I do it from c#?
Select Item, SUM(Price) From Table5 Group By Item
I tried below but not helped. How can I access the values of cmd seperately?
SqlCommand cmd = new SqlCommand("Select Item, SUM(Price) From Table5 Group By Item", sqlConn);
string itemname = cmd.ExecuteScalar().ToString();
|
|
|
|
|
RTFM. ExecuteScalar returns a single result. What you want is ExecuteReader.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
ExecuteReader instead of ExecuteScalar.
Or have it return a string containing both parts, perhaps an XML element. 
|
|
|
|
|
Data reader would be the best.
SqlCommand cmd = new SqlCommand("Select Item, SUM(Price) From Table5 Group By Item", sqlConn);
com.CommandType = CommandType.Text;
SqlDataReader rdr = com.ExecuteReader();
if (rdr.HasRows)
{
string str1 = rdr["Item"].ToString();
}
I appreciate your help all the time...
CodingLover 
|
|
|
|
|
Hi,
I have a question.. If I am going to use the same format of Microsoft error codes in my application development, can anyone explain how do they create the codes? for example what does 0xF89303BC stands for? does every character in this code refer to something?
Thanks..
|
|
|
|
|
I'm pretty sure those are just serial numbers. The microsoft guys are old-school and they probably have gigantic C files with thousands of those codes in there. They just make them up as they need them, I doubt the digits have any meaning. Except maybe they could have prefixes stand for certain products/sub-products.
|
|
|
|
|
|
There are some conventions that most parts of Windows are adhering to. The 32-bit error code then is:
- negative;
- consists of 16-bit component/application code, and 16-bit error code;
- understood by FormatMessage() in kernel32.dll, which returns an approriate error message string.
The lower 16-bit values in this situation are listed in one of the C header files, probably winerror.h
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
Luc provides useful advice as usual. for specific values see here[^].
It's time for a new signature.
|
|
|
|
|
Anyone have any suggestions for alternative grid controls(for desktop)?
I really just need something like GridView, but I like the Infragistics functionality where you can do runtime filtering on the data by clicking the column header and choosing from a list of distinct values. Ideally open source, but at least free. It seemed like a fun project, but I'm sure this particular wheel has been reinvented about a thousand times, so I thought I'd check with you guys.
Is there anything out there like this on CP, or elsewhere?
|
|
|
|
|
Also, hierarchical filtering would be cool too, where you can filter by the groups.
|
|
|
|
|
I have a windows application and i want to distribute banners to be advertised on my main form.. I don't want this to be online.. I want all banners to be on the local PC and then when the user connects to internet then I can update with latest files but I also want to make sure my application won't work if the banners are not exist and to make sure user can not change the banners?
what's your idea?
I thought of a DLL file with the banner files embedded inside that DLL but still the user can replace the DLL with another DLL and display his banners!
what do you think?
|
|
|
|
|
I am not commenting on how annoyed I would be if software on my system did this, nor on how I would probably never use it. 
You could encrypt some form of identifier into the DLL and refuse to run if that is not correct. However since you are using C# and .NET programs are notoriously easy to reverse engineer, it would be ridiculously easy to crack your encryption routines.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
Why do programmers often confuse Halloween and Christmas?
Because 31 Oct = 25 Dec.
|
|
|
|
|
what if i use a resource DLL with banners in it? is it possible to have a code or string or whatever thing to validate the DLL?
|
|
|
|
|
Possible - yes.
Worth the time and effort - no.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
Why do programmers often confuse Halloween and Christmas?
Because 31 Oct = 25 Dec.
|
|
|
|
|
It's probably not worth the trouble. Spend more time on the quality of your application rather than making it unappealing.
|
|
|
|
|
well, but banners in my case is money that's why i am trying to find what's the best way...
|
|
|
|
|
Lack of quality, annoyances, and bad word-of-mouth is not money.
|
|
|
|
|
It's only money if people see them.
How many users have AdBlock on their browser?
How many apps do I use twice if my valuable screen real estate is taken up by unsightly adverts?
And if an app used my bandwidth just to update it's ad supply - how long before it got deleted?
Is your app going to be so useful, so unique, so undo-without-able that everyone must have it? Because if not, then all you will do is drive away potential buyers by the truckload.
The answers by the way: "Lots - because they are truly annoying", "None - because they are truly annoying" and "Measured in nano seconds".
I have learnt that you can not make someone love you, all you can do is stalk them and hope they panic and give in.
Apathy Error: Don't bother striking any key.
|
|
|
|
|
If he gets his money from advertisers then he doesn't need buyers. People have put up with ads for free stuff for quite some time. The numbers of people who use adblock is not large outside of tech people. The millions of people who use Yahoo Messenger, AIM, and MSN Messenger and never bother to use something like Trillian would seem to disprove your point.
For the original poster, you might be re-assured that the largest and most successful software company in the world is going in the same direction as you are. Microsoft announces ad-supported Office Starter 2010[^].
|
|
|
|
|
To get money from advertisers, he need them to buy space on his app: if his users don't exist, the advertisers will bugger off somewhere more effective.
The examples you give work because they provide a huge target audience to potential advertisers.
I have learnt that you can not make someone love you, all you can do is stalk them and hope they panic and give in.
Apathy Error: Don't bother striking any key.
|
|
|
|
|
You most likely have some kind of database. When you update the banners get the checksum[^] for the banner file and store that along with the filename in the database. If, when you load a banner, it doesn't match the recorded checksum then you throw an error because of corrupted data files. You can leave the banners in their native format.
|
|
|
|
|
Then I delete all the records from the database. Or add records that point to images I want to see (porn). 
|
|
|
|
|
No records would cause an error. Anyone who is going to go through the trouble of hacking the datastore and calculating checksums of their own custom images is not worth worrying about. The lost revenue from those people is not significant compared to the cost of protecting against them.
|
|
|
|
|
Maybe. Or maybe I'll publish an article on how to do it, perhaps include a script to make it simple for any other interested users.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
