How to insert multiple rows from form in to database.

Question

Hello Everyone I am trying to insert multiple rows in to database but not sure how to proceed. In the form I am selecting company name and then I need to enter employee records one by one. How to enter the multiple records at a time? Below is my piece of code which works fine for single record when submitting: OracleCommand cmd1 = new OracleCommand(Insert_Employee_Det con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Add(new OracleParameter(fname txtfname1.Text)); cmd1.Parameters.Add(new OracleParameter(lname txtlname1.Text)); cmd1.Parameters.Add(new OracleParameter(address txtaddr.Text)); try { con.Open(); cmd1.ExecuteNonQuery(); } catch (Exception err) { } finally { con.Close(); } Regards.

sita k · Answer

Hi Everyone I wrote the code in order to insert multiple inserts by using grid view.I used private class(App_code) and used it in my coding in anotherfile(ex AddEmployee.aspx).When i run the individual file it is working fine.But when I add that file to sitemap then I am not able to run the application. Do I need to reference the private class in masterpage? Please let me know your valuable suggestions.

Abhay Shanker · Answer

Hi Check this link http://www.codeproject.com/Articles/25457/Multiple-Ways-to-do-Multiple-Inserts

sita k · Answer

Hello Nayak Thanks for the response. But I wanted is to insert emp1 record emp2 record emp3 record at a time while inserting. By using clear it clears the fields after I insert the first records then I can insert the record which is not my requirement. Is there any alternative to insert multiple records at a time? Regards.

Satyapriya Nayak · Answer

protected void btn_insert_Click(object sender EventArgs e) { OracleCommand cmd1 = new OracleCommand(Insert_Employee_Det con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Add(new OracleParameter(fname txtfname1.Text)); cmd1.Parameters.Add(new OracleParameter(lname txtlname1.Text)); cmd1.Parameters.Add(new OracleParameter(address txtaddr.Text)); try { con.Open(); cmd1.ExecuteNonQuery(); } catch (Exception err) { } finally { con.Close(); } clear(); } private void clear() { txtfname1.Text = ; txtlname1.Text=; txtaddr.Text=; }