Click here to Skip to main content
15,168,633 members
Home / Discussions / Database
   

Database

 
Questionwhat does this error means Error converting data type varchar to int. Pin
feeha10-Mar-05 12:27
Memberfeeha10-Mar-05 12:27 
AnswerRe: what does this error means Error converting data type varchar to int. Pin
Edbert P10-Mar-05 16:50
MemberEdbert P10-Mar-05 16:50 
Generalplz help me in the following code Pin
feeha10-Mar-05 12:13
Memberfeeha10-Mar-05 12:13 
GeneralRe: plz help me in the following code Pin
Colin Angus Mackay10-Mar-05 12:35
MemberColin Angus Mackay10-Mar-05 12:35 
GeneralRe: plz help me in the following code Pin
turbochimp14-Mar-05 18:58
Memberturbochimp14-Mar-05 18:58 
Questionhow to save databse along with its data Pin
eshban28410-Mar-05 9:25
Membereshban28410-Mar-05 9:25 
AnswerRe: how to save databse along with its data Pin
Colin Angus Mackay10-Mar-05 11:06
MemberColin Angus Mackay10-Mar-05 11:06 
Generalupdating an SQL table in C# Pin
clemenslinders10-Mar-05 6:59
Memberclemenslinders10-Mar-05 6: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 5:06
Memberledallam10-Mar-05 5:06 
GeneralRe: ADO events Pin
numbrel11-Mar-05 4:55
Membernumbrel11-Mar-05 4:55 
GeneralRe: ADO events Pin
coderChina16-Mar-11 22:35
MembercoderChina16-Mar-11 22:35 
GeneralInspecting / Analyzing transaction log file contents Pin
Hillel9-Mar-05 22:43
MemberHillel9-Mar-05 22:43 
GeneralRe: Inspecting / Analyzing transaction log file contents Pin
Mike Dimmick10-Mar-05 2:49
MemberMike Dimmick10-Mar-05 2:49 
GeneralBDE causes DB Open/Close to lose windows Handles Pin
Pankaj Kahal9-Mar-05 17:39
MemberPankaj Kahal9-Mar-05 17:39 
GeneralRe: BDE causes DB Open/Close to lose windows Handles Pin
Rob Graham10-Mar-05 8:02
MemberRob Graham10-Mar-05 8:02 
Generalwhats the proper defination of view Pin
feeha9-Mar-05 10:28
Memberfeeha9-Mar-05 10:28 
GeneralRe: whats the proper defination of view Pin
ToddHileHoffer9-Mar-05 11:25
MemberToddHileHoffer9-Mar-05 11:25 
GeneralRe: whats the proper defination of view Pin
Colin Angus Mackay9-Mar-05 14:32
MemberColin Angus Mackay9-Mar-05 14:32 
GeneralRe: whats the proper defination of view Pin
Yulianto.9-Mar-05 15:32
MemberYulianto.9-Mar-05 15:32 
GeneralRe: whats the proper defination of view Pin
Colin Angus Mackay9-Mar-05 15:53
MemberColin Angus Mackay9-Mar-05 15:53 
Generalit is givi ng me syntax error Pin
feeha9-Mar-05 8:37
Memberfeeha9-Mar-05 8:37 
GeneralRe: it is givi ng me syntax error Pin
ToddHileHoffer9-Mar-05 9:32
MemberToddHileHoffer9-Mar-05 9:32 
GeneralRe: it is givi ng me syntax error Pin
feeha9-Mar-05 10:26
Memberfeeha9-Mar-05 10:26 
GeneralQuestion on UNION syntax Pin
KreativeKai9-Mar-05 7:06
professionalKreativeKai9-Mar-05 7:06 
GeneralRe: Question on UNION syntax Pin
ToddHileHoffer9-Mar-05 9:35
MemberToddHileHoffer9-Mar-05 9: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.