funtion call in update query

Question

0.00/5 (No votes)

See more:

i am building windows form application.i have to use funtion which is defined in another form how can i call in update query.
"update mytable set id=1 where name=?(here i want to call a funtion i-e fetchname())

Posted 26-Sep-14 1:39am

Nainaaa

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2014-09-26T01:48:00

Solution 1

Call the function, and add the returned value as a parameter:

C#

using (SqlConnection connection = new SqlConnection("YOUR CONNECTION STRING HERE"))
using (SqlCommand command = new SqlCommand("UPDATE mytable SET id = 1 WHERE name = @name", connection))
{
    command.Parameters.AddWithValue("@name", fetchname());
    
    connection.Open();
    command.ExecuteNonQuery();
}

Posted 26-Sep-14 1:48am

Richard Deeming

Comments

CPallini 26-Sep-14 7:49am

5.

anup.bhunia 26-Sep-14 8:02am

note that fetchname(), if defined in another form, you cant call it, unless it is a static function.

better approach would be to bring the function to a separate class and call from both the form.

Nainaaa 27-Sep-14 14:48pm

its not updating the field to 1.

Richard Deeming 29-Sep-14 7:24am

Debug your code. Make sure the method is being called, and that the parameter is set to the value you are expecting.

If it still doesn't work, try running the query in SQL Management Studio. If that doesn't update the record, then there isn't a record in mytable with the specified name.

If running the query from SQL Management Studio updates the record, then your application is not looking at the same database.

funtion call in update query

1 solution

Solution 1

Add your solution here

Preview 0

funtion call in update query

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us