Recent content by raabbasi

Probably, a more appropriate and refined way of my question is that how can I enforce Referential Integrity between 2 or more of my DataTables in VB.NET. Please help.

I am new to ADO.NET. I wish to know how to set a DataRelation object so that; If a row in the Parent DataTable be deleted, the corresponding rows in any Child DataTable objects are also automatically deleted. If the value of the primary key field in the parent row is modified, the change...

I have copied the DataGridCboBoxColumn class into my project and tried to use it on Windows Form as suggested by cmn2 on 16 Nov 05 in this forum. Let me repeat the rest of my problem: I dropped a DataGrid control & a ComboBox control on the form at design time and populated them with data at...

I tried the solution for "Adding ComboBox to DataGrid control" posted on 16th. November. I could not understand the DataGrid part of it. I dropped a DataGrid control & a ComboBox control on the form at design time and populated them with data at run-time. Both the controls are displaying data...

I appreciate your consistent response. Regards. R. A. Abbasi

Thanks Christiaan Baes for the response. Is VB.NET Express Edition fully functional for developing small-scale applications or is it for learning purpose only? Please let me know. R. A. Abbasi

After installing Microsoft .NET Framework 2.0 on top of Microsoft .NET Framework 1.1, how can I use the later Framework version, in my already installed, VB.NET 2003 programs instead of the earlier one? Any advice will be appreciated. R. A. Abbasi

Sorry, both of you are right. Thanks and regards. R. A. Abbasi

I don't think CommandText has anything to do with the CommandBuilder object.

I tried the expected GetUpdateCommand method of the CommandBuilder object to retrieve the Update Query generated by the object. But, it just returns the fully qualified name of the object ("System.Data.OleDb.OleDbCommand"). I could not find any other way. If anyone can let me know, how can I get...

Great help from Steve. Thanks and best regards.

OleDbCommandBuilder was not supposed to be included. Please elaborate more on the suggestion "amend the DataRows returned from the resulting select query and then update the dataset". I am precisely interested in using the Update method of the DataAdapter object. Regards.

The following procedure does not Update the record(s). '--------------------------------------------------------- Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click Dim dadapter As OleDbDataAdapter = New OleDbDataAdapter...

Unfortunately there is no help pertaining to this particular scenario. A solution with the Update method of the DataAdapter (Not using the ExecuteNonQuery method of the Command object) will be highly appreciated.

Thank you very much Christiaan Baes for the response. The ExecuteNonQuery method is quite straightforward. As a matter of fact, I am interested in finding a solution with the Update method of the DataAdapter for an academic purpose and I believe, there will be a way to do it. Further help will...