Click here to Skip to main content
15,918,343 members
Home / Discussions / Database
   

Database

 
GeneralRe: DTS: Transform Task > Stored Procedure > Temp Table error Pin
GuyThiebaut23-Oct-07 22:35
professionalGuyThiebaut23-Oct-07 22:35 
QuestionHow to reset the identity Pin
devboycpp23-Oct-07 4:56
devboycpp23-Oct-07 4:56 
AnswerRe: How to reset the identity Pin
Pete O'Hanlon23-Oct-07 5:00
mvePete O'Hanlon23-Oct-07 5:00 
AnswerRe: How to reset the identity Pin
Mitesh Darji23-Oct-07 22:52
Mitesh Darji23-Oct-07 22:52 
QuestionUpdate Query Cant seem to spot the problem Pin
ekynox23-Oct-07 2:56
ekynox23-Oct-07 2:56 
AnswerRe: Update Query Cant seem to spot the problem Pin
squattyarun23-Oct-07 3:05
squattyarun23-Oct-07 3:05 
AnswerRe: Update Query Cant seem to spot the problem Pin
Paddy Boyd23-Oct-07 3:06
Paddy Boyd23-Oct-07 3:06 
GeneralRe: Update Query Cant seem to spot the problem Pin
ekynox23-Oct-07 3:20
ekynox23-Oct-07 3:20 
I am getting no error. The output of ExecuteNonQuery is an "int" type. The value of this int variable indicates how many rows have been modified. In my case its zero when infact it should be one. I have one row of data in the table that needs to be updated so it should return 1 not 0.

I can verify that order of parameters matches what is in the table.

Any other suggestions I can try out ?

Edit:
Running the code like this works fine:
<br />
public void UpdateCustomer(CustomerInfo customer)<br />
{<br />
            string query = "UPDATE CUSTOMER SET Name = " + "'" + customer.Name + "'," + "Age = " + customer.Age + " WHERE ID = " + customer.ID;<br />
            OleDbCommand command = new OleDbCommand();<br />
            command.CommandText = query;<br />
            command.Connection = this.connection;<br />
            command.Connection.Open();<br />
            try<br />
            {<br />
                int x = command.ExecuteNonQuery();<br />
                Debug.WriteLine(x.ToString());<br />
            }<br />
            catch (Exception ex)<br />
            {<br />
                throw new Exception(ex.Message, ex.InnerException);<br />
            }<br />
            finally<br />
            {<br />
                command.Connection.Close();<br />
                command.Dispose();<br />
            }<br />
}<br />

GeneralRe: Update Query Cant seem to spot the problem Pin
Paddy Boyd23-Oct-07 3:43
Paddy Boyd23-Oct-07 3:43 
AnswerRe: Update Query Cant seem to spot the problem Pin
Rob Graham23-Oct-07 7:53
Rob Graham23-Oct-07 7:53 
GeneralRe: Update Query Cant seem to spot the problem Pin
ekynox23-Oct-07 10:32
ekynox23-Oct-07 10:32 
QuestionDelete Pin
ritu432123-Oct-07 1:35
ritu432123-Oct-07 1:35 
AnswerRe: Delete Pin
sindhutiwari23-Oct-07 1:41
sindhutiwari23-Oct-07 1:41 
GeneralRe: Delete Pin
pmarfleet23-Oct-07 1:48
pmarfleet23-Oct-07 1:48 
AnswerRe: Delete Pin
pmarfleet23-Oct-07 1:43
pmarfleet23-Oct-07 1:43 
AnswerRe: Delete Pin
N a v a n e e t h23-Oct-07 1:57
N a v a n e e t h23-Oct-07 1:57 
GeneralRe: Delete Pin
ritu432123-Oct-07 2:11
ritu432123-Oct-07 2:11 
GeneralRe: Delete Pin
N a v a n e e t h23-Oct-07 2:14
N a v a n e e t h23-Oct-07 2:14 
GeneralRe: Delete Pin
sindhutiwari23-Oct-07 2:22
sindhutiwari23-Oct-07 2:22 
GeneralRe: Delete Pin
pmarfleet23-Oct-07 3:19
pmarfleet23-Oct-07 3:19 
AnswerRe: Delete Pin
Krish - KP23-Oct-07 2:19
Krish - KP23-Oct-07 2:19 
Questionstoring image in access database Pin
sindhutiwari23-Oct-07 1:21
sindhutiwari23-Oct-07 1:21 
AnswerRe: storing image in access database Pin
N a v a n e e t h23-Oct-07 1:33
N a v a n e e t h23-Oct-07 1:33 
GeneralRe: storing image in access database Pin
sindhutiwari23-Oct-07 1:39
sindhutiwari23-Oct-07 1:39 
GeneralRe: storing image in access database Pin
N a v a n e e t h23-Oct-07 2:03
N a v a n e e t h23-Oct-07 2:03 

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.