User-719153870 posted
Hi Dhoni,
Dhoni
Anyone Please share Code for Temporary Store Multiple records Data Before Insert database
Assume you are talking about store multiple records temporary in c# and then insert them to sql server database.
The common way you can achieve your requirement is to store your records in a datatable in session.
Please refer to Save and retrive datatable from session variable using C# in ASP.Net.
The code using a session datatable and ADO.NET is also easy to understand:
private string Constr = ConfigurationManager.ConnectionStrings["Constring"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Country", typeof(string));
dt.Rows.Add("Peter", "USA");
dt.Rows.Add("John", "Franch");
Session["Customers"] = dt;
}
protected void Insert(object sender, EventArgs e)
{
DataTable dtCustomers = Session["Customers"] as DataTable;
SqlConnection con = new SqlConnection(Constr);
con.Open();
foreach (DataRow row in dtCustomers.Rows)
{
SqlCommand cmd = new SqlCommand("INSERT INTO Customers Values(@Name,@Country)", con);
cmd.Parameters.AddWithValue("@Name", row["Name"]);
cmd.Parameters.AddWithValue("@Country", row["Country"]);
cmd.ExecuteNonQuery();
}
con.Close();
}
If i misunderstood anything or you met any problem, please feel free to tell.
Best Regard,
Yang Shen
