datatable

I am filling a datatable contained within a dataset from a datadapter in a separate thread. What I want to do is see if this datatable is still being "filled" so that I wait until its done before I call upon it from the primary thread. Is there a status in the datatable that shows that it is...

Hi! I am new to this forum and to programing in visual basic .net! I am sure there is an easy solution but I am stuck!! I have a question: I have a program with a SQL 2008 backend with a table called p_timesheets inside of which is a field called tsDate stored as date. I am able to pull the...

Hello all, I have a DataSet(dssongs) with a DataTable(dtsongs) on a form(songsForm). I am adding rows to the dataTable using the following code: Dim dr As DataRow = songsForm.dtSongs.NewRow dr.Item("colSongFile") = file dr.Item("colSongTitle") = ""...

Hello all, I'm trying to make a program in which football (or some other sport) prognostics can be entered and scores can be calculated automatically. I've set up the database and I've created 3 layers. In the data layer, I've added my access 2007 database (it already has the right links...

My system use to run on from a access database. Now I created the database on a MySQL server. I can connect to it using the connection wizzard, but I prefer using my old methods as shown below. I used this to connect to my access database: Private Function MYDATA() As DataTable Dim...

Good Afternoon All, I'm fairly new at VB.Net and Visual Studio so please bear with me if what I'm asking seems ridiculous. I would like to query a MS SQL Server database (not on the local machine) and store the results in a so-called "in-memory" DataTable. I've done this... not too...

Confused!! I am trying to fill a DataTable with a DataSet using a SQL query with one parameter. The parameter is the Node text of a treeview whose checkbox has been checked. It will retrieve Products from one table and any associated Packages from a different table. I am using a FOR loop to...

I have a simple question (but the answer could be complex :)). Is is at all possible to retreive data from DataRowView, or is that not what it is for? What I have done is create a dataview from a datatable: oleDataAdapter.Fill(dsDocTypes) dvDocTypes = dsDocTypes.DefaultView Then I used the...

Hi, I try compare two dataTables. Here a example: OldDt = Dt ' The idea is keep the old values before refresh the dataTable refresh(Dt) ' refresh this dataTable with the SQL Table. If Equals(OldDt, Dt) Then Debug.WriteLine("true") Else...

Hi, I made a class for access (read and write) to SQL database Tables. Each time, that mi class execute a command, this call to private method for "Refresh" a Internal DataTable that, this class have for access to info from the instance. The question is: had the .net any way for detect that...