Click here to Skip to main content
15,868,016 members
Home / Discussions / Database
   

Database

 
Questionwhat does this error means Error converting data type varchar to int. Pin
feeha10-Mar-05 11:27
feeha10-Mar-05 11:27 
AnswerRe: what does this error means Error converting data type varchar to int. Pin
Edbert P10-Mar-05 15:50
Edbert P10-Mar-05 15:50 
Generalplz help me in the following code Pin
feeha10-Mar-05 11:13
feeha10-Mar-05 11:13 
GeneralRe: plz help me in the following code Pin
Colin Angus Mackay10-Mar-05 11:35
Colin Angus Mackay10-Mar-05 11:35 
GeneralRe: plz help me in the following code Pin
turbochimp14-Mar-05 17:58
turbochimp14-Mar-05 17:58 
Questionhow to save databse along with its data Pin
eshban28410-Mar-05 8:25
eshban28410-Mar-05 8:25 
AnswerRe: how to save databse along with its data Pin
Colin Angus Mackay10-Mar-05 10:06
Colin Angus Mackay10-Mar-05 10:06 
Generalupdating an SQL table in C# Pin
clemenslinders10-Mar-05 5:59
clemenslinders10-Mar-05 5:59 
Hi I'm using some DevExpress components in C#. Using sqlConnection, sqlDataAdapter, dataSet, gridControl (a Datagrid) and controlNavigator (to choose insert record, edit record etc.).

When I make my program I can see all the data in the table. Using the controlNavigator I can add records, delete them etc.

I use Microsoft SQL server 2000.

I understand that my program loads a local copy of the database and at the end I have to let the program know that the real table now needs to be updated.

I made a button under which I can test some commands.

I tried sqlDataAdapter1.Update(dataset11) and sqlDataAdapter1.Update(DataSet11,"films") (where films is the name of the table) also I tried dataSet11.acceptchanges().

No matter what I try each time when I quit the program and restart the program my table is empty.

What do I need to do to effectivly change/update the real table??

I would like a solution where I can input/change data in the datagrid using the controlNavigator and then by adding somewhere some extra code make the changes permanent.

I hope someone can help

Kind regards,


Clem
GeneralADO events Pin
ledallam10-Mar-05 4:06
ledallam10-Mar-05 4:06 
GeneralRe: ADO events Pin
numbrel11-Mar-05 3:55
numbrel11-Mar-05 3:55 
GeneralRe: ADO events Pin
coderChina16-Mar-11 21:35
coderChina16-Mar-11 21:35 
GeneralInspecting / Analyzing transaction log file contents Pin
Hillel9-Mar-05 21:43
Hillel9-Mar-05 21:43 
GeneralRe: Inspecting / Analyzing transaction log file contents Pin
Mike Dimmick10-Mar-05 1:49
Mike Dimmick10-Mar-05 1:49 
GeneralBDE causes DB Open/Close to lose windows Handles Pin
Pankaj Kahal9-Mar-05 16:39
Pankaj Kahal9-Mar-05 16:39 
GeneralRe: BDE causes DB Open/Close to lose windows Handles Pin
Rob Graham10-Mar-05 7:02
Rob Graham10-Mar-05 7:02 
Generalwhats the proper defination of view Pin
feeha9-Mar-05 9:28
feeha9-Mar-05 9:28 
GeneralRe: whats the proper defination of view Pin
ToddHileHoffer9-Mar-05 10:25
ToddHileHoffer9-Mar-05 10:25 
GeneralRe: whats the proper defination of view Pin
Colin Angus Mackay9-Mar-05 13:32
Colin Angus Mackay9-Mar-05 13:32 
GeneralRe: whats the proper defination of view Pin
Yulianto.9-Mar-05 14:32
Yulianto.9-Mar-05 14:32 
GeneralRe: whats the proper defination of view Pin
Colin Angus Mackay9-Mar-05 14:53
Colin Angus Mackay9-Mar-05 14:53 
Generalit is givi ng me syntax error Pin
feeha9-Mar-05 7:37
feeha9-Mar-05 7:37 
GeneralRe: it is givi ng me syntax error Pin
ToddHileHoffer9-Mar-05 8:32
ToddHileHoffer9-Mar-05 8:32 
GeneralRe: it is givi ng me syntax error Pin
feeha9-Mar-05 9:26
feeha9-Mar-05 9:26 
GeneralQuestion on UNION syntax Pin
KreativeKai9-Mar-05 6:06
professionalKreativeKai9-Mar-05 6:06 
GeneralRe: Question on UNION syntax Pin
ToddHileHoffer9-Mar-05 8:35
ToddHileHoffer9-Mar-05 8:35 

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.