- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
try
{
using (var context = new vbEntities())
{
var DBF = new DBF();
var dt = DBF.GetAll(@"C:\Users\.........\Documents\BNKSEEK.DBF");
int i = 0;
progressBar1.Maximum = dt.Rows.Count;
foreach (DataRow dr in dt.Rows)
{
var row = new Bank();
row.BIK = dr["RKC"].ToString();
row.CityName = dr["NNP"].ToString();
row.Address = dr["ADR"].ToString();
row.Name = dr["NAMEP"].ToString();
row.KS = dr["KSNP"].ToString();
row.Phone = dr["TELEF"].ToString();
row.OKPO = dr["OKPO"].ToString();
context.Bank.Add(row);
progressBar1.Value = i++;
}
context.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}