How to insert multiple rows from form in to database.
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 kPosted Dec 1, 2013, 5:02 AM
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 ShankerPosted Nov 28, 2013, 10:13 PM
http://www.codeproject.com/Articles/25457/Multiple-Ways-to-do-Multiple-Inserts
sita kPosted Nov 28, 2013, 3:06 PM
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 NayakPosted Nov 28, 2013, 1:42 PM
{
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="";
}