Ado.net

[kewldudehere]

Hi,

I am new to ASP.NET. I have a small task to be completed.
I have form that has various textboxes that are filled by results of dataset.
If any changes are made in the value of text boxes, i need to update the changes back to the database.
How to Approach to this solution??

[dip_developer]

Hi,

I am new to ASP.NET. I have a small task to be completed.
I have form that has various textboxes that are filled by results of dataset.
If any changes are made in the value of text boxes, i need to update the changes back to the database.
How to Approach to this solution??

what is the problem with plain UPDATE ???

[kewldudehere]

I have to update 3 tables. Should i create 3 sqlcommand objects and use the same connection object or is there any better way?

[dip_developer]

I have to update 3 tables. Should i create 3 sqlcommand objects and use the same connection object or is there any better way?

write a update function for creating command objects.....
pass your three query string to this function....
there will be one connection object...but if you have tables in different databases then connection string should be different

[Vijeybabu]

Hi,

I am new to ASP.NET. I have a small task to be completed.
I have form that has various textboxes that are filled by results of dataset.
If any changes are made in the value of text boxes, i need to update the changes back to the database.
How to Approach to this solution??

Do you want to update the value using TextBox1_TextCh anged Event OR using Update Button.....?