Just perform an INSERT statement during each info class iteration
//I'll assume you already have a connection object, so we will call it "cn"
string sql = "INSERT into myTableName (Category, Number, Account, Amount, Date) Values (@Cat, @Num, @Acc, @Amt, @Dt)";
foreach (Info i in myList)
{
cn.Open();
using (SqlCommand cmd = new SqlCommand(sql, cn))
{
//Category
SqlParameter param = new SqlParameter("@Cat", SqlDbType.VarChar, 20);
param.Value = i.Category;
cmd.Parameters.Add(param);
//Number
SqlParameter param = new SqlParameter("@Num", SqlDbType.VarChar, 20);
param.Value = i.Number;
cmd.Parameters.Add(param);
//Account
SqlParameter param = new SqlParameter("@Acc", SqlDbType.VarChar, 20);
param.Value = i.Account;
cmd.Parameters.Add(param);
//Amount
SqlParameter param = new SqlParameter("@Amt", SqlDbType.VarChar, 20);
param.Value = i.Amount;
cmd.Parameters.Add(param);
//Date
SqlParameter param = new SqlParameter("@Dt", SqlDbType.VarChar, 20);
param.Value = i.Date;
cmd.Parameters.Add(param);
//Execute Insert
cmd.ExecuteNonQuery():
cn.Close();
}
}
John Grove - TFD Group, Senior Software Engineer, EI Division, http://www.tfdg.com
