insert query to insert into two table at once

Why do you want to store the same image in two places? It is a big waste of space, and leads to the possiblity of the two getting out of step. Instead, why not create a table of images, with just the image and related info, and an ID, and refer back to that from both tables?

Try this

let me explain suppose i have two tables 'abc' and 'xyz'

First of all i have created the following storedprocedure.

Create PROCEDURE procemp
@Empcode numeric,
@FName nvarchar(100),
@LName nvarchar(100),
@sex nvarchar(100),
@age numeric
AS
BEGIN
Insert into abc(Empcode,FName, LName) values (@Empcode,@FName, @LName)
Insert into xyz(Empcode,sex,age) values (@Empcode, @sex,@age)
END
GO

after creating the above procedure i executed this procedure by providing parameters as under

execute procemp 1,'a', 'b','male',28

if you want insert data into two table then
repeat your insert query

means your insert query will be fire two times on the single event.

e.g

on button click

insert into table1(stu_id,names,emailid) values (@stu_id,@names,@emailid)
insert into table2(stu_id,class,age) values (@stu_id,@class,@age)


i hope its help u.

Stored procedures, IMHO really fits in this scenario. My suggestion is to create a stored procedure where you can put the 2 insert statements and then call it from your SQLCommand. One advantage of doing such over executing the command twice is you are able to rollback the script incase something goes wrong in the process.

create triger after insert on the table MyImageTable
and write query in the trigger