Is this statement true? "ADO.NET doesn't have it's own engine to connect to a data source, it uses ADO internally. It's another layer on top of ADO. It's pretty much the same as doing an interop with the ADO components... " ...more >>

I have a question regarding indexes. This may be a SQL newsgroup question. If it is I apologize. I actually posted it on both just in case. If I create an index on a table. Will this index be checked through when I execute a select statement from VB.NET or is this index only used through st...more >>

I'm trying to save a time (08:01 for example) to a Data/Time field (formatted Short Time) in an Access table using VB.NET. The problem is that even when I write this time to a dataset, it winds up saving as #08/28/2003 08:01 AM# in the database, where the date is today's date. In plain ol' VB...more >>

Hi! I was wondering if there is a "better" way to use dataset's instead of using "someset.Tables["sometable"].Rows[index][index]" in order to get the content out of the datatables. I think "collections" is what I'm looking for, though I'm really not sure. I have a dataset that has 8 tables ...more >>

Using an ODBCConnection and ODBCDataAdapter object, I am able to connect to a CSV file. However, my data tables are all comeing back with the first line of the CSV file used as a column header line. How do i disable this? TIA// ...more >>

If I do the following code I get nothing returned. Dim i As Integer For i = 0 To ds.Tables(0).Columns.Count - 1 If ds.Tables(0).Rows(0).HasErrors Then MsgBox(ds.Tables(0).Rows(0).GetColumnError(i)) End If Next I get a message box for every column and message boxes are alwa...more >>

I'm trying to populate a treeview from a SQL tables in C#. i've written the SQL procedures (i.e. database wise is sorted). However, I would like to see an example of how to retrieve the data from the tables (recrusive method). I finally worked out how to retrieve the data. it was just a matter...more >>

I cannot get my recordcount to show up properly (using ADO 2.5). It keeps showing -1! Here's a snippet: Dim dbMyDb As New ADODB.Connection Dim rsWebData As New ADODB.Recordset dbMyDb.Open gConnectionString rsWebData.Open "SELECT * FROM WebDataLogAc;", dbMyDb, adOpenKeyset...more >>

I have a sql string that I put through a connection object to fetch my data out of vfp tables using the oledb driver, and then bind it to a datagrid in vs.net 2003. The sql contains a left join between 2 numeric fields, and every time the table on the right side of it has no matching record for...more >>

Here is the scenario: I have a hierarchical data grid. I click on expansion sign on row (this row is not the currently selected row) and then navigate to show the detals of that row. Now is there a way to get the row on which I clicked to navigate to the child-rows?...more >>

I am using OracleDataAdapter.FillSchema() to get the primary key information for the table used in the query string assigned to the command. If the table is referenced directly (such as SELECT * FROM SCHEMA.TABLE) I get the array of DataColumns in the primary key. If the table is referenced th...more >>

Hi, I'm binding a DataTable to several controls and everything seems to be reflected okay. When comes to updating the database, I'm calling DataTable's Select(string.Empty, string.Empty, DataViewRowState.ModifiedCurrent) and passing this DataRow[] into SqlDataAdapter's Update() method....more >>

I'm currently debugging an application. Unfortunately, it is one of those problems that happens sporadically, and I haven't found a reliable way to reproduce it. The basic structure of my code is: try { // execute some update stored procedures sqlTransaction.Commit(); } catch ...more >>