hello friendz ..

 i m a newbie in the .net world. & having a problem in inserting the data in database.

 i want to insert the same data into the 2 different tables in the database at the same time.

 can u plzz suggest me the solution or give me the code of that in c# language.

 thanx.

Smmie

Have you tried using a stored procedure, this seems like the most straightforward way to do something like this?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========

This requires two separate insert queries. This can be done with two queries strung and executed together (separated by a ";") like this:

INSERT INTO MyTable1(...) VALUES(...); INSERT INTO MyTable2(...) VALUES(...)

Or, as Doug suggests, put them together in a stored procedure. This also allows you to make the insert transactional.

-Peter