VS.2005 I have several lookup combo boxes in my windows project and would like to do a "lighter weight" binding. Currently I am using a strongly typed dataset with a binding source as the DisplayMember and ValueMember. This seems like overkill since I don't use much of the datatable funct...more >>

Hi, I'm trying to archive orginal records, so what I am trying to do is upon saving the changed record also writing the orginal record version to a different table. The problem I'm having is that the DataTable.ImportRow does not accept a datarowview as a parameter. My code is below, can s...more >>

How do I determine if there are any rows within the BindingSource that have changed prior to calling the EndEdit(). I need to do this in order to archive some records and if I call the EndEdit() then it also wipes out the orginal version of the dataset record with the proposed changes., Howe...more >>

I have a web service that queries a db and loads an array of class objects with data from the dataset. The class looks like the following: public class MyData{ public string Data1{get{return mdata1;}} public string Data2{get{return mdata2;}} private string mdata1; private string mdata2; ...more >>

I have a large table of customer data. It is a host of sales data. Actually all of the invoices to all customers. I'm only interested in total sales to each customer. I'd like to query the dataset and come away with total dollars by customer. I read several articles on scalar queries and...more >>

Hi, Hope someone can help me I have a datagridview I want to print Code below works fine if I print the data if there is only 1 page (without using hasmore pages '!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! If intRowPos <= 10 Then e.HasMorePages = False Else e.HasMorePages = True End If '!!!...more >>

Hi, I'm just running through some examples of data binding in c# and am seeing a lot of references to the DataConnector object, however I can't find the object in my code, it should be in System.Windows.Forms but its not, am I missing a reference. The details of my visual studio are: Micr...more >>

I can write a bunch of code to use a datagridview with two related tables, but I'm hoping to be able to use the bindingsources to do it instead. I'm not getting any exceptions, but the datagridview is only displaying the child columns instead of both the parent and child. What I'm doing is s...more >>

Hi all First things first, I do not use multithreading to update any control, all re-marshalled onto the UI-thread. I do not rebind the control, I add/remove rows in the underlying tables, all on the UI-thread. The SqlConnection is not shared and it is contained in a "using" block (so hopefully i...more >>

Hi all I am currently using a Bound Read Only data grid. What I am looking to do is have different colour rows depending on the data in the row. EG. If the status = Closed then that row should be Red, If the Status = Open then That row should be Green. I am trying not to loop through...more >>

I have a form I think databinding is causing some problems with, but I'm not sure. To simplify things, let's say I have two text boxes (called categoryCodeMaskedTextBox and categoryDescTextBox) databound to bindingSourceCategories and five buttons (cmdNewCategory, cmdCancelCategory, cmdDel...more >>

Hi, My exact question is: ¿ How can I CANCEL the addition of a new datatable row that comes from an bindingsource's event ? I have a datagridview attathed to a bindingsource. The bindingsource is attached to a dataset with a datatable. On the datatable I have a primary key defined...more >>

Hi, I got a problem with binding custom objects to the controls. Let's say we have 2 objects: obj1 and obj2. In my case DataGrid column is bound to the obj1 and ComboBox in that column is bound to the collection of obj2 and has its ValueMember as Guid and DisplayMember as string from the ob...more >>

Hi! What is the best way to restrict changes of a datatable, which is not bound to a DataGridView but rather to separate Controls (Textboxes, Datetimepicker...) through a binding source. If I want to restrict updates, I want to do this centrally on the DataView the BindingSource is bound to...more >>

Hi I have a custom class that I am binding to a usercontrol using the built in databindings in Visual studio 2005. I add a my class as a datasource to my project and then drag and drop the class onto my form. This creates a load of textboxes etc on the form as you would expect. My problem ...more >>

Hello, I'm trying to remove columns from my datagridview, but an error appears: sub reload() .. .. DataGridView1.Columns.RemoveAt(1) 'or DataGridView1.Columns.Remove("column_name") .. .. end sub Errors: "La operación no se puede realizar en este controlador de eventos." (So...more >>

Is there a better combo on the market than that piece of crap with the DropDownList bug? I cannot believe this was not fixed between VS2003 and VS2005. ...more >>

Hello. How can I bind ADODB.Recordset to DataGrid? I really need to bind it to many third party controls. I there some adapter class that implements all necesarry interfaces to bind it? Or I must implement these interfaces on my own? Thanks in advance. ...more >>

VS 2005 SP1. Googled without success. I have an array of structs, and some of the elements are arrays of structs. E.g., ------------------------------------- public struct foobar { public int ID; public string Name; public foo[] FooFields; public bar[] BarFields; } public ...more >>