SelectCommand

[alef34]

I have one question: In Help about odbcDataAdapter.Update Method is write text: Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the DataSet. And when is calling SELECT statement? I need sometimes calls on my odbcDA select command, which refresh my DataSet. Update can not I call, in my Table is not change, but in Dataset I take data from RelAted Table. Julo Julo Jenis

[Dave Kreskowiak]

Update doesn't call a SELECT statement. It's used for UPDATING. All three SQL statements make changes, or UPDATE, the database. When do you call the SELECT statement? Here's a hint: How did you fill your dataset in the first place? RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

[Len Miller]

You need to do OdbcDataAdapter.Fill(dataset) This will use the select command to fill the dataset Thanks, -Len Miller "If I had eight hours to chop down a tree, I'd spend six sharpening my axe." -Abraham Lincoln

[alef34]

Ok, thats clar, but... I have one DataGrid, 5 Tables and relations between Tables. When am I in 3 table, I do som changes. I 2 Table (2.Table is Parent of 3Table) I have one field, which is SUm of fileds in 3 Table. When I come to 2 Table, I need make "Refresh", t.m. SELECT. But when I use FILL, In DataGrid is 1 Table. Calculated field I cann not use, there is som problem with "Cannot change read only property for calculated field" :-() When you know something about my problem, pease help me. Thanks, Julo