Declere Target table twice in the mapping and move the output to both the target tables.

Ans4:

select name from tablename where name like
'A%';

bowlaaaaaaaaaaaa! is the correct answer

ans 4
select * from emp where ename like 'A%'

2. select * from <tablename> where <coloumn-name1>='<value>'and <coloumn-name2>='<value>'.........

1.How to enter same record twice in target table? give me syntax.
A)To insert a same record in to the target table twice, use the fill method of dataadapter twice and update the dataset
add the following lines of code

sqlconnection cn = new sqlconnection("ur connection string");
Sqldataadapter da= new sqldataadapter("select * from sometable",cn);
sqlcommandbuilder cmb = new sqlcommandbuilder(da);
dataset ds= new dataset();
da.fill(ds,"sometable");
ds.tables[0].constraints.add("usr_pk",ds.tables[0].columns[0],true);
datarow row;
row=ds.tables[0].newrow();
for(int i=o;i<2;i++)
{i++;
row[0]=value;
ds.tables[0].rows.add(row);
da.update(ds.tables[0]);

If you have the better answer, then send it to us. We will display your answer after the approval.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question