Save data into data table dynamically and then save the data table into database in C#

Thank you for posting at Dotnetfunda
[Administrator]

Regard's
Raj.Trivedi
"Sharing is Caring"
Please mark as answer if your Query is resolved

Thank you for posting at Dotnetfunda
[Administrator]

DataTable dt = new DataTable();

        dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)),

                            new DataColumn("Name", typeof(string)),

                            new DataColumn("Age",typeof(string)) });

        dt.Rows.Add(1, "Ankit", "21");

        dt.Rows.Add(2, "Anuj", "22");

        dt.Rows.Add(3, "Anish", "24");

        dt.Rows.Add(4, "Ankush", "22");

string sql = "INSERT INTO Student_detail (Name, Age) VALUES (@A, @B)";

        using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString))

        {

            conn.Open();

            foreach (DataRow r in dt.Rows)

            {

                SqlCommand cmd = conn.CreateCommand();

                cmd.CommandText = sql;

                cmd.Parameters.AddWithValue("@A", r["Name"]);

                cmd.Parameters.AddWithValue("@B", r["Age"]);             

                cmd.ExecuteNonQuery();

                

            }

            Response.Write("<script> alert('Saved Successfully');</script>");

        }