|
How to bind SQL data to RadHtmlChart-pie telerik control? All example are just binding static data only, i want to know how to bind sql query result (Name and total) columns in RadHtmlChart-pie?
|
|
|
|
|
Your question indicates a dramatic lack of understanding, the demo will show you how to bind DATA (a collection) to the chart, whether it is static or sourced from the database is your job.
Make a connection to the database
Use a command to query the table(s) you need
Get the results into a collection (presumably name and total)
Use the demo to give you an example of how to bind the collection to the chart.
Get a book on the subject and work through the examples you will enjoy programming a lot more with a deeper understanding.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have a Treeview with checkboxes. I want to be able to click on a checkbox and change the node BG color. If the checkbox is unchecked then I want to default BG color. I've searched around and saw some things that were close but didn't exactly do both of these things.
Thanks for any help...
|
|
|
|
|
Assuming you are using winforms - you don't mention your UI. Look for a NodeClick event, in that event you write your code based on the content of the node (sender, although the sender may be the treeview and you need the SelecteNode).
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
Thanks...with your help, I got it to work...in this case with that little 'e' arg:
private void treeView_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
{
if (e.Node.Checked)
{
e.Node.BackColor = Color.Yellow;
}
else
{
e.Node.BackColor = Color.White;
}
}
|
|
|
|
|
BTW, I placed my cursor on the 'TreeNodeMouseClickEventArgs' argument in VS 2012 and pressed F1 for the MSDN help on what that 'e' represents and it mentioned nothing about it. What is that called anyway?
|
|
|
|
|
Please start posting these kinds of questions in Q&A, clearly tagging them to indicate if they are WinForms, WPF, or whatever.
My sense is you are not spending enough time really studying how to use .NET controls, and you are asking for "more help than you really need," far too frequently.
Do you have a good book on basic WinForms programming with example code for you to study, and use ?
imho, there's no substitute for hands-on careful study, on your own, with the WinForms Controls: most of them are really kind of "fossils" from the old days of COM and ActiveX, dressed-up for the .NET party, and each of them has their own "quirks."
The Visual Studio IDE and Property Browser are great tools for studying what the defaults of Control Properties are, and what Properties, and Events, and settings, are available. Experiment !
imho, you also need to spend a little time studying the CodeProject guidelines, and how CP works.
I, and others will, I'm sure, be happy to assist you to "walk forwards along" the path towards mastery of WinForms, but I, and most likely others, will not "carry you;" if we did, you would not really learn.
yours, Bill
~
“This isn't right; this isn't even wrong." Wolfgang Pauli, commenting on a physics paper submitted for a journal
|
|
|
|
|
I'll post in the Q&A as you suggest. I'm a bit older and the C# and .net coding is harder for me to grasp. I do spend a lot of time googling for answers but often the code I find I just don't understand it.
For example, I do see that Sender arg a lot and try to use it like Sender.Checked on a node checkbox but that doesn't work. I also see the e args and try using e.Checked and that doesn't work. sometimes the this. member works ok and other times not.
Seems to me if your coding in C# that the C# group would be where one should post vs the Q&A but I'm sure you have a reason for asking me to not post here in C#.
|
|
|
|
|
Hi RFresh,
It's not my intention to be critical, or patronizing, but I do think that if you are at the point where you don't have a clear grasp of the fundamentals of what a WinForms EventHandler, and its sender/EventArgs parameters, are, you may be studying "hard," but not "smart."
I strongly suggest you start off by using a resource like this free book, "Dot Net Book Zero," by Charles Petzold [^], and bear down it. Or, Jesse Liberty's over-view books on C# are excellent (O'Reilly).
If you are coming from a deep-background in COM, ActiveX, C/C++, to WinForms, then I'd recommend Chris Sell's book on Windows Forms (Addison-Wesley); disclaimer: I was a paid technical editorial assistant on that book.
Just to be clear, my opinion that the type of specific questions you are asking on this Forum (now) are best served in Q&A, are just my opinion, and I do not represent, or speak for, CP in any way.
The general idea is that forums like this one are meant to be for discussion of broader issues in using C# ... but that's my interpretation.
good luck, Bill (who started programming after age forty)
~
“This isn't right; this isn't even wrong." Wolfgang Pauli, commenting on a physics paper submitted for a journal
|
|
|
|
|
Bill,
Thanks for the pointers...I will get Charles' book.
|
|
|
|
|
I added the 'Menu' item to VS 2012 Express (using C#) toolbox but its disabled. At work I'm using VS 2012 Premium and added the Menu item to the toolbox and it did not disable it and thus I could make use of it.
Anyone know why the Express version might be disabling the Menu component on the toolbox menu?
Thanks...
|
|
|
|
|
I'm trying to save one of my settings.settings fields when I close my VS 2012 C# app but I'm getting an error saying this is a read-only property. Where so I change it to read/write?
Thanks...
private void FormMain_FormClosing(object sender, FormClosingEventArgs e)
{
Properties.Settings.Default.emailAddress = "someone@isp.com";
}
|
|
|
|
|
If your setting is a User Setting, you need to save all the current User Settings to make them persist between Application use; if your Setting is an Application Level Setting, you cannot change it at run-time. In the Visual Studio Settings Designer you can change the scope of a Setting to 'User.
Properties.Settings.Default.Save(); Quote: Settings that are application-scoped are read-only, and can only be changed at design time or by altering the .config file in between application sessions. Settings that are user-scoped, however, can be written at run time just as you would change any property value. The new value persists for the duration of the application session. You can persist the changes to the settings between application sessions by calling the Save method. [^]
I found the information here useful: [^].
~
“This isn't right; this isn't even wrong." Wolfgang Pauli, commenting on a physics paper submitted for a journal
|
|
|
|
|
Ahhhh...yes, the difference (for me) was that I had some items set to Application and thus they were read-only. I changed them to User and can now save their data.
Thanks Bill.
|
|
|
|
|
Bill, this is the oddest site to find things, you mention before to delete a message and repost it but there was no way to delete. Now you're suggesting I vote a thank you which I 100% agree with but I don't see anything regarding voting. Strangest site!
|
|
|
|
|
There are little red (down vote) and green (up vote) arrows to the left of the message you want to vote on. Just open the message and move your mouse towards the left side under the document icon and it'll show the voting arrows.
At the bottom of your messages are the links to edit/delete, etc. You can use those too.
|
|
|
|
|
Yep, I went to look again and finally figured that out!!! Up vote to you Bill...!!
|
|
|
|
|
rfresh wrote: Up vote to you Bill..
But you still have not upvoted his message.
Use the best guess
|
|
|
|
|
I dont have a habit of using try-cahtch block unless i am sure it throws an exception... is it advisable to use it in most places of your code.... what is the best practice?
Srinivas K
|
|
|
|
|
Srinivas Kalabarigi wrote: what is the best practice?
To only catch what you can handle. If you can't handle it, don't catch it. If it doesn't throw exceptions, don't try.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
You mean to say its not good practice to catch all....?
Unless necessary... right
Srinivas K
|
|
|
|
|
Srinivas Kalabarigi wrote: You mean to say its not good practice to catch all....?
It's a known anti-pattern; catching all is the worst practice, a remnant of the "On Error Resume Next" lazyness.
Catching an unexpected exception might lead to unexpected behaviour (since your app is in an unknown state), data-loss, and generally makes it harder to solve bugs.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy Vluggen wrote: Catching an unexpected exception might lead to unexpected behaviour... (
Except of course that in servers
1. Not catching it means it is lost.
2. Most of the time, most errors are non-disruptive. For example null pointer errors, and in a correctly designed layered system such errors, although unexpected, will not stop the application.
|
|
|
|
|
It is a good practice to catch exceptions; but if someone is sure about some exception then it is better to work on your code so that it doesn't throw any exception; let's say if divide by zero throws an exception then you shouldn't allow your code to reach to that point so that division by zero may occur. In that case it is not recommended to use the try-catch block but it is recommended to not let your code reach to that point so that that exception may occur.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
