Click here to Skip to main content
15,905,144 members
Home / Discussions / C#
   

C#

 
GeneralRe: message boxes Pin
Heath Stewart3-Feb-04 18:04
protectorHeath Stewart3-Feb-04 18:04 
GeneralPrintPreviewDialog Pin
Anonymous3-Feb-04 1:16
Anonymous3-Feb-04 1:16 
GeneralRe: PrintPreviewDialog Pin
Heath Stewart3-Feb-04 4:18
protectorHeath Stewart3-Feb-04 4:18 
GeneralRe: PrintPreviewDialog Pin
Anonymous4-Feb-04 1:05
Anonymous4-Feb-04 1:05 
GeneralRe: PrintPreviewDialog Pin
Heath Stewart4-Feb-04 3:42
protectorHeath Stewart4-Feb-04 3:42 
GeneralRe: PrintPreviewDialog Pin
Anonymous4-Feb-04 4:07
Anonymous4-Feb-04 4:07 
GeneralSerialization of object references Pin
sps-itsec463-Feb-04 0:43
sps-itsec463-Feb-04 0:43 
GeneralRe: Serialization of object references Pin
Heath Stewart3-Feb-04 4:25
protectorHeath Stewart3-Feb-04 4:25 
GeneralRe: Serialization of object references Pin
sps-itsec463-Feb-04 6:18
sps-itsec463-Feb-04 6:18 
GeneralRe: Serialization of object references Pin
Heath Stewart3-Feb-04 6:38
protectorHeath Stewart3-Feb-04 6:38 
GeneralDecimal Places Pin
Reinier van de Wetering2-Feb-04 19:41
Reinier van de Wetering2-Feb-04 19:41 
GeneralRe: Decimal Places Pin
Rampas Tomas2-Feb-04 22:32
Rampas Tomas2-Feb-04 22:32 
GeneralRe: Decimal Places Pin
Heath Stewart3-Feb-04 4:36
protectorHeath Stewart3-Feb-04 4:36 
GeneralDatagrid row Color Pin
Reinier van de Wetering2-Feb-04 19:19
Reinier van de Wetering2-Feb-04 19:19 
GeneralRe: Datagrid row Color Pin
Mazdak2-Feb-04 22:09
Mazdak2-Feb-04 22:09 
GeneralRe: Datagrid row Color Pin
Reinier van de Wetering3-Feb-04 19:19
Reinier van de Wetering3-Feb-04 19:19 
GeneralRe: Datagrid row Color Pin
Reinier van de Wetering3-Feb-04 19:49
Reinier van de Wetering3-Feb-04 19:49 
GeneralUpdating DataBase Pin
GetOn&GetGoing2-Feb-04 18:40
GetOn&GetGoing2-Feb-04 18:40 
GeneralRe: Updating DataBase Pin
Mazdak2-Feb-04 22:05
Mazdak2-Feb-04 22:05 
GeneralRe: Updating DataBase Pin
Heath Stewart3-Feb-04 4:43
protectorHeath Stewart3-Feb-04 4:43 
You need to use a DataAdapter (for this, I'll assume a SqlDataAdapter and related classes) with SelectCommand, InsertCommand, UpdateCommand, and DeleteCommand properties assigned. If you use a simple SELECT query (i.e., no JOINs or nested SELECTs) you can use a SqlCommandBuilder to generate the other 3 SqlCommand properties from the SqlCommand for the SqlDataAdapter.SelectCommand property. These commands must also be parameterized.

You can also use the VS.NET designers to create the SqlDataAdapter and all the SqlCommands for you. You can drag a DataSet (which can be strongly-typed) or SqlDataAdapter from the "Data" tab of your toolbox when a component is open in the designer. Play around with this, though I recommend you examine the code that is generated in the source file to understand what it going on.

 

Microsoft MVP, Visual C#
My Articles
Generalgetting graphics card info Pin
Member 93287482-Feb-04 17:45
Member 93287482-Feb-04 17:45 
GeneralRe: getting graphics card info Pin
Mazdak2-Feb-04 18:31
Mazdak2-Feb-04 18:31 
GeneralDrag & Drop Interface Pin
johnstacey2-Feb-04 15:05
johnstacey2-Feb-04 15:05 
GeneralRe: Drag & Drop Interface Pin
John Fisher3-Feb-04 4:22
John Fisher3-Feb-04 4:22 
GeneralRe: Drag & Drop Interface Pin
Heath Stewart3-Feb-04 4:54
protectorHeath Stewart3-Feb-04 4:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.