|
I suspect this isn't possible but before I completely abandon the idea I'd thought I'd post and ask. I have two database tables structures as follows:
Table1
AreaID
CategoryID
Amount
Table2
AreaID
AmountTotal
I need to display the share that each category has of the overall area total, each area has many categories. The easy solution (and maybe the correct one) is to have a datatable which looks like this
DataTable
AreaID
CategoryID
Amount
AreaAmountTotal
and bind the Share column to an expression of Amount / AmountTotal. However this means the AreaAmountTotal is stored for every record that has the same area id and this struck me as inefficent. I'd thought to use a relational dataset with two datatables structured the same as the database tables and bind the share column to an expression across both tables but this doesn't seem possible (or at least I find no examples of it anywhere).
It looks like I could achieve this by not binding the datagridview to anything and programmatically populating the grid but development speed is an issue and we were hoping to minimise writing very much code.
Thanks in advance!
Robert.
|
|
|
|
|
No, not really, but you can build a DataView object using the multiple tables and bind the DGV to the DataView.
|
|
|
|
|
I've had a look at DataView and it doesn't seem to support more than one table, can you point me at an example of that?
I did stumble across the JoinView http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B325682[^] which does support mulitple tables so I'll have a look at that (written in VB .Net though I guess that doesn't matter).
|
|
|
|
|
Hi,
Can you please give me some idea of how to use the sqlprofileprovider in windows forms application.
with regards,
Anand
|
|
|
|
|
hi
actually i have build wix aplication which i want to installed from flash
drive to other machine but i want installation should not copy files to
target machine it should run only when the flash drive is plugged ,after
setting all the feature and component run-from-source , msi installtion
copying file in target machine. and in the verbose log it shows all featur
and compnent run-from-local.
it is not runing from source why? 
|
|
|
|
|
Hi all,
Do you know any library (free or commercial) that is for programming Adobe illustrator file (*.ai).
Thank you very much.
VietTH2004
|
|
|
|
|
Hi Vietth,
I have read that the latest Expression Blend can read Adobe Illustrator and PhotoShop fles, but I have not tried this myself.
Hope that's relevant to your question.
best, Bill
"Many : not conversant with mathematical studies, imagine that because it [the Analytical Engine] is to give results in numerical notation, its processes must consequently be arithmetical, numerical, rather than algebraical and analytical. This is an error. The engine can arrange and combine numerical quantities as if they were letters or any other general symbols; and it fact it might bring out its results in algebraical notation, were provisions made accordingly." Ada, Countess Lovelace, 1844
|
|
|
|
|
Windows 7 Application Compatibility labs are available around the USA. These half-day labs help you overcome any issues in getting applications ready for Windows 7. The labs are free. Lab times are available during the week.
This offering will give you the opportunity to test your application on Windows 7 to determine compatibility and performance characteristics. You will have the opportunity to work with Microsoft while gaining an understanding of how to manage and optimize your product in a Windows 7 environment.
| City | Start | End |
|---|
| Mt View, CAT | June 1 | June 5 | | Reston, VA | June 8 | June 12 | | Alpharatta, GA | June 15 | June 19 | | Waltham, MA | June 22 | June 26 |
Sign up at http://www.msregistration.com/Win7USA[^]
|
|
|
|
|
how to save data from excel sheet and want to store in sql database
DOT NET
|
|
|
|
|
Do some work, this question has been answered many times try here clickety[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I like to simulate Mobile UI using Windows Forms.
I want some pointer to implement following features,
1. How to display cursor(horizontal cursor "_" and vertical cursor "|") inside
text box control
2. How to get cursor position and move the cursor.
Some one can also suggest whether TextBox control is enough for the above implementation or whether i should go with RichTextBox control
thanks
|
|
|
|
|
Is bing broken where you are?
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.”
|
|
|
|
|
I am not getting you henry!
|
|
|
|
|
bing = search engine
Your questions have been asked 1000s of times before and a search will get you the answers quicker that asking a question in the forum. If you have not tried a search engine in the last 14 hours I suggest you do so.
If bings is not working you may want to try google.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thanks for your reply.
I posted this query after searching through net and going through codeproject.
There are many features available for WindowsCE! I am working on WindowsForms.
I am hardcore C Programmer, I am introduced to C++ because of MFC/Visual Studio to create gui to my back end C program library.
I am switching over from MFC to windows forms as i am informed that WF is easy than MFC. I am learning Windows Form now, and i see examples for VB, C# and C++. I prefer to use C++ as i can manage and understand the same compare to other.
I created Windows Forms project using following options:
File->New->Project->VC++(main option)->Windows Forms Application in Visual Studio 2008 professional edition.
I really dont know whether C# or C++ is used by default by the VS2008 while creating the template!
I looked into this site http://msdn.microsoft.com/en-us/library/system.windows.forms.cursor(VS.71).aspx
my requirement is I wish to change the cursor based on button press inside the text control and back to default on clicking another button. I used following code.
private: System::Void button4_Click(System::Object^ sender, System::EventArgs^ e) {
// creating new cursor
System::Windows::Forms::Cursor= gcnew System::Windows::Forms::Cursor("MyCur.cur");
// this should set a cursor for all TextBox inside the form
System::Windows::Forms::TextBox::Cursor::set(mycur);
//setting the focus to textBox1
textBox1->Focus();
}
// to get default cursor
private: System::Void button5_Click(System::Object^ sender, System::EventArgs^ e) {
System::Windows::Forms::Cursor::Current = System::Windows::Forms::Cursors::Default;
}
Result: on button4 press, the whole form gets the new cursor. And the focus given to textBox1, with default cursor!
on button5 press, it is not reverting back to default cursor.
modified on Tuesday, June 2, 2009 8:51 AM
|
|
|
|
|
I have not used C++ since before the advent of Windows Forms, so I would not venture to attempt to offer you any code snippets.
However speaking in Windows Forms terms, each TextBox instance has its own Cursor property and it is this that needs to be set. If you need to change the cursor for all TextBoxes on a Form/Control you will need to iterate over the Controls property of the Form/Control and test if the control is a TextBox and then set the Cursor property to the desired cursor. Since TextBox inherits the Cursor property from Control there is no need to cast before doing so.
I hope that this helps, but if not perhaps someone with C++ skills will help you.
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.”
|
|
|
|
|
oh my god henry i love bing! i think it's way cooler that g%%gle!
|
|
|
|
|
It is called "caret", not "cursor".
|
|
|
|
|
Agreed.
Uwe Keim wrote: caret
|
|
|
|
|
Does anyone know of an off-the-shelf 4-panel splitcontainer that allows me to resize all 4 panels together? I can acheive something similar by nesting 3 split-containers together like so:
_________________________
| | |
| TL | TR |
| | |
|=======================|
| | |
| BL | BR |
|__________|____________|
TL = Top Left
TR = Top Right
BL = Bottom Left
BR = Bottom Right
My outer splitContainer is the one with the horizontal split, then then I have 2 vertical splitContainers, one for top and one for bottom, giving me 4 panels. I can resize the 2 top or 2 bottom ones horizontally, or all 4 vertically, but I can't resize all 4 horizontally. What I'd like is something like the above, but I can click on the location where all 4 panels meet and resize them together. I tried searching for "4 way splitcontainer" and "4 panel splitcontainer" but nothing really came up. Everything I've seen involves nesting splitContainers.
Any suggestions are appreciated.
Dybs
|
|
|
|
|
I don't know if you will be able to get it to work exactly as you require, but the TableLayoutPanel with two columns and two rows would get pretty damned close.
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.”
|
|
|
|
|
Henry,
Thanks for the suggestion. I'll give it a try later today.
Dybs
|
|
|
|
|
I tried the TableLayoutPanel, but it didn't quite give me what I wanted. The layout is fine, but I want to be able to resize the cells using the mouse, just like with the SplitContainer. I checked the documentation and a couple of other forums, and it looks like you can resize whole rows or columns via code, but not the mouse (at least there's no built-in support). I'd like to end up with something like this:
__________________________
| | |
| | |
|------o------------------|
| | |
| | |
| | |
|______|__________________|
where I click and drag the 'o' the resize all 4 panels simultaneously. I would think someone has already made something like this, but if not I guess I can handle the MouseDown, MouseMove, and MouseUp events to get the effect I want. Any other suggestions?
Thanks,
Dybs
|
|
|
|
|
As you say, I'm sure that someone must have done something like this, but if you are unable to find anything, the Mouse handling route would seem to be the way to go.
When its finished, perhaps you could write an article about it.
Good luck! 
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.”
|
|
|
|
|
So I've finally had some time to work on this a bit more with a co-worker. We implemented the MouseDown, MouseMove, and MouseUp events to handle resizing rows and columns in the TableLayoutPanel, and for the most part it works well. Still having some resize issues when the form resizes to keep the cells right (we're using Absolute size, maybe need to switch to Percent). Might be an article in it, have to check company policy since it was written specifically for work.
Dybs
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
