One button click Data must be send into Three tables(SQL)
My form has three different fields like personal details, educational details and communication address by clicking on one button those three fields data must be send to three tables in database...
Hardik BhavsarPosted Feb 3, 2014, 1:47 AM
sqlcommand cmd=new sqlcommand();
cn.open();
string query1 =" insert into PersonalDetails (ColumnNames) values (Fields)";
cmd.executenonquery("query1",cn);
string query2 =" insert into EducationDetails (ColumnNames) values (Fields)";
cmd.executenonquery("query2",cn);
string query3 =" insert into CommunicationDetails (ColumnNames) values (Fields)";
cmd.executenonquery("query3",cn);
cn.close();