DataGridView VS2005
-
Hi! I need to load a DataGridViewComboBoxCell from dynamic SQL data and the other DataGridViewTextBoxCell from another SQL datasource. Thats not it... i need also be able to edit one single value from it. For exmple, I need to be able to select some item or insted be able to insert a new value to get from some insert qerry. All this for earch row in a normal DataGridView Component from Visual Studio .Net 2005 tnks! :^)
___________________________ vykom's best. Free your mind! use GPL. up to open source!!!
-
Hi! I need to load a DataGridViewComboBoxCell from dynamic SQL data and the other DataGridViewTextBoxCell from another SQL datasource. Thats not it... i need also be able to edit one single value from it. For exmple, I need to be able to select some item or insted be able to insert a new value to get from some insert qerry. All this for earch row in a normal DataGridView Component from Visual Studio .Net 2005 tnks! :^)
___________________________ vykom's best. Free your mind! use GPL. up to open source!!!
If you need to populate a DataGridView from multiple sources, you can do that using DataBindingSource with no problem. You can either specify a data member for each column manually, or I'd go for making a DataView with the custom view you want to make using a SQL SELECT statement. About your second question, I don't really understand what you want to do. Maybe you could give an example or be more specific?
Regards:rose:
-
If you need to populate a DataGridView from multiple sources, you can do that using DataBindingSource with no problem. You can either specify a data member for each column manually, or I'd go for making a DataView with the custom view you want to make using a SQL SELECT statement. About your second question, I don't really understand what you want to do. Maybe you could give an example or be more specific?
Regards:rose:
well, tnks for that. About the second question, what I need is something like this: Some user, can manually select an item loaded in the DataGridViewComboBoxCell, but, in any case, he can manually insert a value typing it too. That's why I can't explicity load all items from a BindingSource or TableAdapter normally, because I wouldn't add or edit any item from the control. Y try getting the full action over "mouseclicked" and "itemselected", but I couln't add an item in the combo .... exception released because i'm trying to edit all the concurrency of the BindingSource. And also loading the commbo manually, I couln't draw a simple TextBox in the place of the ComoboBoxCell.. It's kind of tricky. (sorry my english)
___________________________ vykom's best. Free your mind! use GPL. up to open source!!!
-
well, tnks for that. About the second question, what I need is something like this: Some user, can manually select an item loaded in the DataGridViewComboBoxCell, but, in any case, he can manually insert a value typing it too. That's why I can't explicity load all items from a BindingSource or TableAdapter normally, because I wouldn't add or edit any item from the control. Y try getting the full action over "mouseclicked" and "itemselected", but I couln't add an item in the combo .... exception released because i'm trying to edit all the concurrency of the BindingSource. And also loading the commbo manually, I couln't draw a simple TextBox in the place of the ComoboBoxCell.. It's kind of tricky. (sorry my english)
___________________________ vykom's best. Free your mind! use GPL. up to open source!!!
I guess you'd have to do it manually. You'd check if the value written in the combobox is available in your datasource. If not add it directly in the datasource using a SQL Statement. Did I get you right this time, or am I still astray?
Regards:rose:
-
I guess you'd have to do it manually. You'd check if the value written in the combobox is available in your datasource. If not add it directly in the datasource using a SQL Statement. Did I get you right this time, or am I still astray?
Regards:rose: