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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|