Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008


all groups > dotnet ado.net > october 2003 > threads for sunday october 19

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

why to use GetChanges of a DataSet???
Posted by Daniel Walzenbach at 10/19/2003 8:01:59 PM
Hi, =20 I have seen a lot of code using .GetChanges of a System.Data.DataSet = like the following: =20 myDataSetWithChanges =3D myDataSet.GetChanges myDataAdapter.Update(myDataSetWithChanges) =20 Does this approach make any sense? I mean that Update of the DataAdapter = has to...more >>

Newby: Filling ComboBox?
Posted by Mr. B at 10/19/2003 7:23:31 PM
I'm 'verrrry' new to DB's... never have used them in the past. And I'm a week-end programmer (ie: for 'fun' rather than work). But now I'm trying to develope a rather complicated Windows Form using MSAccess db files. Our company inputs our weekly time sheets into a MSA db... it then gets imp...more >>

Work with Relational Data
Posted by penghao98 NO[at]SPAM hotmail.com at 10/19/2003 6:55:28 PM
I know by using myDataSet.Relations.Add(), two related tables can be joined together. Is there a way more than two tables can be joined together? Thank you for your help....more >>

Migrating to ADO.NET and locks
Posted by Tom Pester at 10/19/2003 5:12:43 PM
I just started to work with ADO.NET and I had some problem with locks that it caused on our sql server. In classic ADO I didnt close the connection (sloppy of me I know) and it didnt cause many problems. After executing the following code in a ASP.NEt : Dim conn As New SqlConnection("Data S...more >>

porting code for sqlsvr to my-sql
Posted by VISOR at 10/19/2003 4:33:01 PM
Hi. Is there any fast and automated way to port an application written for sqlserver with sqlConnection, sqlDA and so on to work with MySQL? I've seen there are some providers for mysql. Anyone knows some way to convert the program at cthe code level to support mysql? thanks....more >>

Filter rows in a DataSet
Posted by Hardy Wang at 10/19/2003 4:29:24 PM
Hi all: I have a DataSet populated with values. How can I return ds.Tables[0].DefaultView's records from a starting number to a ending number? For example, I have 100 records in the DefaultView, but I just need records from 25th to 50th. Thanks for any suggestion! -- W...more >>

Connection Pool
Posted by Satish at 10/19/2003 8:52:31 AM
Hi Friends What is connection pool in theory and how to work with connection pool from .NET Many thanks Satish ...more >>

more on can't get connection to open
Posted by dennist NO[at]SPAM zahav.net.il at 10/19/2003 8:25:14 AM
I have a full discourse in a recent post. But the problem starts at the beginning. I start the program with sub main. I put in msgboxes right at the beginning to see where I stood before the error. When I run the application, the message boxes before the cn.open statement are not poppe...more >>



CommandBuilder & Update
Posted by george baburanos at 10/19/2003 7:15:57 AM
The problem is that when I edit an insert command generated by the cb resets the commandtext whenever I do an update with the related DataAdapter. <VB CODE> sqlc = New SqlClient.SqlConnection(sConnection) da = New SqlClient.SqlDataAdapter(sSelect, sqlc) ds = New DataSet c...more >>

Can someone explain wiring between datagrid and a Find method?
Posted by Larry Woods at 10/19/2003 7:15:47 AM
I have a combobox and a datagrid on a form (VB.NET). I have the DataSource of each set to a datatable. I use the combobox "SelectedValue" to perform a Find in the combobox SelectedIndexChanged event procedure. Here is what confuses me: Performing the Find repositions the datagrid display. ...more >>

can't get connection to open
Posted by dennist NO[at]SPAM zahav.net.il at 10/19/2003 6:46:45 AM
I first wrote a simple program filling a bunch of comboboxes, filling a textbox, a doing a couple other things. It worked fine, everytime. All the code of this project is at the end of this post. Then I tried to take it a step further. That step was to check all the comboboxes, a coupl...more >>


DevelopmentNow Blog