DataBase Connection Update Record or Update Database

[Debasis Bag]

Dear Sir,

I am fresher in vb.net but I have experience in vb 6.0. But I want to connect database in sql server through sql connection. In that case how to create connection with window or sqlserver authintication mode and how to add or update new record in data base in batch transaction. Please help me with sample code.
So that I can understand eassily.


Thanking You

Debasis Bag

[Shuja Ali]

You should take a look at 101 samples on msdn (http://msdn.microsoft.com/en-us/vbasic/ms789075.aspx#data). They will be very helpful to learn most of the things about the data access in .NET.

[Shuja Ali]

Please do not create duplicate threads with the same question. If you are not satisfied witht eh answer given, please post in the same thread.

I have removed the duplicate thread that you had posted.