I'm trying to use a form created with the VB.NET Data Form Wizard. When I try to test the form by adding data, I get the above error message (the record does not get added and it erases a non-related field!). The value in the field is not a NULL value. This seems only to happen to key fields - n...more >>

I have an object and a strongly typed collection (inheriting collectionbase) of that object. The collection also implements iBindingList. I am attempting to run some of my own code in the OnSet or the OnSetComplete methods. But when I put a breakpoint in those events, I do not seem to hit t...more >>

I created a form that is displayed as DialogBox for the user. The form has couple of Textbox that are bound to the Dataset and shows the current value in them correctly. " TextBox1.DataBindings.Add("Text", DS, "TableName1.FieldName1"); TextBox2.DataBindings.Add("Text", DS, "TableName1.FieldNa...more >>

Hi I have an application that has in memory tables which are related. I have recently upgraded to 2003 MSDN - which seems to have thrown an error which I did not have before. Here is the scenario... First I build a couple of simple tables: ______________________________________________...more >>

Hi! I have a datagrid bound to a dataset and also i have a textbox bound to the same dataset. when i navigate in my datagrid i want the textbox also navigate automatically with my datagrid because textbox is using the same dataset as it's datasource. for example when i go to record number 1...more >>

I have a few issues with databinding. First of all, I read so much about how painful it seemed to be for people that I initially started out not using it. As in, if I do things manually, at least I know what is going on. However, I liked what I read about the ErrorProvider and the SetRowErr...more >>

Hello, I've developed a lot of database-systems in Microsoft Access. Now I'm going to develop a large system in VB.NET. Before I start, I'm testing some performance differences between MS Access and VB.NET. When I connect to a large table (more than 100.000 records) from a database with MS Ac...more >>

I have been unable to google the right keywords to this hopefully easy answer. I bind a combobox: With cboOperator Dim operator As OperatorDataTable = _company.Operator .DataSource = operator .DisplayMember = operator.Name.ColumnName ....more >>

Hi How do i set a row readonly after applying custom table styles and binding to a datasource?? i need to set particular rows readonly, but i do not know what they are until i have loaded data from my tables. Regards Darryn ...more >>

hi all, i have this error anyone knows how to solve it ??? thks JSB at System.Windows.Forms.CurrencyManager.get_Item(Int32 index) at System.Windows.Forms.CurrencyManager.get_Current() at System.Windows.Forms.ErrorProvider.ErrorManager_CurrentChanged(Object sender, EventArgs e...more >>

I have a picturebox on my windows form. In this picturebox I'm going to keeppictures of the employees. I can save the images to my access table (tblPhoto.PhotoObject) I want to be able to populate my picturebox with the image of the employee. How can I go about binding it, or having the image ...more >>

Hi I have a NullableDateTimePicker control inherited from DateTimePicker control (windows forms). The NDTP has a property SmartDate of the type SmartDate (SmartDate is a class enhancing DateTime with a Nullable functionality). I have a business object name Project with several properties, ...more >>

[Reposted here as probably more appropriate than "microsoft.public.vb.controls.databound"] Could anyone help with the following scenario? - I have a class that exposes a collection (a Hashtable actually) as a property.(called Custom). - I am custom binding a WinForms DataGrid control to a c...more >>

Hi, I already sent this question however I can't seem to find it so I'm gonna submit it again. I'm populating .dbf and access tables into my datasets. These files are coming from clients so the layouts always change therefore I can't rely on using typed datasets. Is there a way of getting...more >>

Hi, I am using C# with VS Studio 2003. I would like to display in one DataGrid control (Windows Forms) a combination of fields that are selected from 2 tables. My questions are: 1. How can it be performed, using DataAdapter and DataSet? 2. How can it be performed, using Typed DataSet? A det...more >>

Hi, I know in .NET in order to call a stored procedure passing parameters, you have to add parameters to the SqlParameter collection. I want to know if there is a way to call stored procedures in this format: Command.Execute StoreProc Par1, Par2, Par3, Par4, Par5 This is how I was doing ...more >>

Hi, I'm using a DataGrid with a master/detail setup. I allow navigation, so the grid has the little "plus boxes" and the link to the child table. Can anybody tell me how to setup custom GridColumnStyles. I try the various DataSources such as the relation and so forth, but I can only customize...more >>

Hi, I am using Visual Studio 2003. I was wondering how can I display only some of the columns of a dataset in a datagrid. For example, if my dataset has columns A,B,C,D and I want to display only columns A and C. ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com...more >>

I have a dataTable with only one unique record and want to bind this to a couple of textboxes in a form, so that when a user changes a value, it's eventually reflected back to the database. The dataset I use is 'untyped' - so I'm not able to do a typed databind, and this is causing me great...more >>

Anybody knows how to bind enumerated type to a data bound combo box? I tried this: this.comboBox1.DataSource = Enum.GetValues(typeof(CheckType)); this.comboBox1.DataBindings.Add("SelectedItem",this.objtest.Tables["Attribute"],"CheckType"); When i navigate records the combo didnt reflect the val...more >>

Hi, I am creating a new dataview with from my dataset like so: mydv = New DataView mydv = ds.Tables("table1").DefaultView then I bind my combo box to one of the fields: cbo.DataBindings.Add("SelectedValue", ds, "field1") This works fine, however when i set the dataview AllowEdit prop...more >>

I have a typed DataSet which holds my application data. I use it for data binding in several forms. When setting the DataSet as a data source in my form the UI designer generates code which creates a new instance of my DataSet. So each form is referring to an own instance which's not my inte...more >>

i have a class like: public class MyClass { public MyClass() {} public SecondClass SC=new SecondClass (); } public class SecondClass { public SecondClass () {} public string test=""; } i'd lik to bind DC.test to a textBoxt. I've tried : MyClassMC=new MyClass(); textB...more >>

Hi! is it possible to set Rowfilter property to multiple fields such as this: dataview1.rowfilter = "Customer = " & "'" & me.txtcustomer.text & "'" dataview1.rowfilter = "Order_ID = " & "'" & me.txtOrder_ID.text & "'" dataview1.rowfilter = "orderd_Item = " & "'" & me.txtorderd_Item.text & "'" ...more >>

I have a simple object with some boolean properties which I've databound to some checkboxes, these in turn affect a text control which is also bound and this all works after a fashion. What I want it to be able to do is to change the text whenever a checkbox is selected, not when a check box l...more >>

All, I have a custom object that inherits from CollectionBase. When I set my datagrid.datasource property to this data grid I get the fields I want, however the count property of the CollectionBase object is shown as well. I am sure I need to explicitly define which columns I would like...more >>

I have a table called orderdetails which has a composite key. It is made of OrderID+ItemCode. The OrderID comes from the Orders table and the ItemCode comes from the Items table.(Foreign Key Constraints) I have a winform application where i have a combobox which displays the OrderID from ...more >>

Hi, All I have a datagrid binded to a datasource. I want to display a lookup field in the same grid. I also want to display a calculated field in datagrid i.e. Qty x Rate (Amount). How is it possible. TIA ...more >>

I have built a very simple single form Application, with a sqlDataAdapter, sqlConnection, dataSet and a Grid. As soon as I load the application and bind the data there are two connections from my App in SQL Server. Can anyoone explain why this is, and if this means my App will take up two l...more >>

I have this problem. I have bind a textbox and if I write with keyword a text, it's saved correctly, but if I change the value by programs es. textbox1.text="aaaa"; the value isn't save. Why ? What happened of different when I write in a textbox or change the value from program ? thanks ...more >>

Hi All, I have a very simple User Control containing a textbox and label control. I expose a ControlText and LabelText property to allow the control's contents to be set as well as the label's text (which is simply a caption for the textbox). When I bind the ControlText property to a DataS...more >>

I do not think it is good style to use these because you have to hardcode the propertynamed in your code as string literals. Wouldn't it be better to use delegates instead? myComboBox.DisplayMember = new ReturnStringDelegate(myObj.Name); myComboBox.Valuemember = new ReturnObjectDelegate(myObj....more >>

Does anybody know if it's possible to use a a view, or something like it, to pull together columns from different datatables into one view to bind to a datagrid? ...more >>

When I try to bind a checkbox and the data for the field is null I get an error 'Object cannot be cast from DBNull to Other types'. Also when I use AddNew I also get the same error. I must allow for 0, 1 or null data. My code is as follows: ckActive.DataBindings.Add(new Binding("checked", ...more >>

Hi All, I bind a Textbox with a datarow. When I update the value of a field in datarow, the new value doesn't automatically display in the Textbox. Could you tell me how to solve this problem; Ex: txtSoftwareSN.DataBindings.Add("Text", row, "SoftwareSN"); // DataRow row ...more >>