how to update database

[prajaktaran]

hey,
how can i update the database of SQL server 2008 while using win application
as front end

thanks
prajaktaran

[finito]

Show code.

if you want the SQL code here.

UPDATE Table SET Column = 'value' WHERE Column2 = 'value123'

[thines01]

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executenonquery.aspx

[Singleton]

You might want to check out LINQ to SQL, or the Entity Framework. This is an easier route which requires no knowledge of sql. Consult MSDN for some examples.

[prajaktaran]

Hi,

Thank you for your reply.

I want to make the changes on the windows application that can be stored on the database.

Like
I want to make change in some address on front end that can be stored in SQL which is back end when i click the update button

what is the syntex for "loaddatarow"

Thank u

prajaktaran

[finito]

Prajaktaran Please read provided link.

the read this http://quickstart.developerfusion.co.uk/quickstart/howto/doc/adoplus/UpdateDataFromDB.aspx