Trying to insert multiple rows data of Dataset in a table.

Question

I wrote a code to insert multiple rows from dataset into a sql table. I put insert inside foreach loop scope but it take first row only. Please check the code below string query, feetype, feename, feeamt; //Get Fees charges from Fees Master sda = new SqlDataAdapter( "select class,fees_type,fess_name, fee_amount from tb_fee_master where class='" + stclass + "' and not fees_type='Monthly'" , sc); ds = new DataSet(); sda.Fill(ds, "t" ); if (ds.Tables[0].Rows.Count != 0) { stclass = ds.Tables[0].Rows[0][0].ToString(); feetype = ds.Tables[0].Rows[0][1].ToString(); feename = ds.Tables[0].Rows[0][2].ToString(); feeamt = ds.Tables[0].Rows[0][3].ToString(); int x = 0; foreach (DataRow dr in ds.Tables[0].Rows) { if (dr.Table.Rows.Count > 0) { query = "insert into tb_std_fee (class,fee_type,fee_name, amount) values (@class,@fee_type,@fee_name, @amount)" ; cmd = new SqlCommand(query, sc); cmd.Parameters.AddWithValue( "@class" , stclass); cmd.Parameters.AddWithValue( "@fee_type" , feetype); cmd.Parameters.AddWithValue( "@fee_name" , feename); cmd.Parameters.AddWithValue( "@amount" , feeamt); sc.Open(); x = cmd.ExecuteNonQuery(); sc.Close(); } } if (x != 0) { MessageBox.Show( "Fees register created successfully." ); } }

Vivek Kumar · Answer

Hi, Have a look to below links. https://www.c-sharpcorner.com/blogs/insert-multiple-rows-at-a-time-from-c-sharp-to-sql

Sanwar Ranwa · Answer

Hello Mohit Please check these Links https://www.fourthbottle.com/2014/09/how-to-insert-multiple-records-into.html https://www.c-sharpcorner.com/blogs/insert-multiple-rows-at-a-time-from-c-sharp-to-sql https://www.dotnetcurry.com/ShowArticle.aspx?ID=323