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

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.");
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.