private void importfromExcelToDB(string filepath)
{
CustomerForm.Helper hl = new CustomerForm.Helper();
if (System.IO.File.Exists(filepath) == false)
{
return;
}
DataTable dtimport = hl.dtFromExcelFile(filepath, "Contacts");
int reccount = 0;
string DQ = "\"";
MySqlConnection conn = new MySqlConnection();
label3.Text = "Importing Records to Database Please Wait...";
label3.ForeColor = Color.Blue;
label3.BackColor = Color.White;
label3.Visible = true;
try
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["mysqlconn"].ToString();
foreach (DataRow dr in dtimport.Rows)
{
string ph = dr["phone"].ToString().Replace(" ", "");
string strmycomd = "insert into customer(firstname,lastname,email,phone,address) " +
"values (" + DQ + dr["firstname"] + DQ + ", " + DQ + dr["lastname"] + DQ + ", " + DQ + dr["email"] + DQ +
", " + DQ + ph + DQ + ", " + DQ + dr["address"] + DQ + " );";
MySqlCommand mycmd = new MySqlCommand(strmycomd, conn);
conn.Open();
mycmd.ExecuteNonQuery();
conn.Close();
reccount++;
}
}
catch (MySqlException mex)
{
MessageBox.Show("Error " + mex);
}
finally
{
conn.Close();
}
label3.Text = "Importing Records Complete..(" + reccount + ")";
label3.ForeColor = Color.Blue;
label3.BackColor = Color.White;
label3.Visible = true;
}
private void importfromExcelToDB(string filepath)
{
CustomerForm.Helper hl = new CustomerForm.Helper();
if (System.IO.File.Exists(filepath) == false)
{
return;
}
DataTable dtimport = hl.dtFromExcelFile(filepath, "Contacts");
int reccount = 0;
string DQ = "\"";
MySqlConnection conn = new MySqlConnection();
label3.Text = "Importing Records to Database Please Wait...";
label3.ForeColor = Color.Blue;
label3.BackColor = Color.White;
label3.Visible = true;
try
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["mysqlconn"].ToString();
foreach (DataRow dr in dtimport.Rows)
{
string ph = dr["phone"].ToString().Replace(" ", "");
string strmycomd = "insert into customer(firstname,lastname,email,phone,address) " +
"values (" + DQ + dr["firstname"] + DQ + ", " + DQ + dr["lastname"] + DQ + ", " + DQ + dr["email"] + DQ +
", " + DQ + ph + DQ + ", " + DQ + dr["address"] + DQ + " );";
MySqlCommand mycmd = new MySqlCommand(strmycomd, conn);
conn.Open();
mycmd.ExecuteNonQuery();
conn.Close();
reccount++;
}
}
catch (MySqlException mex)
{
MessageBox.Show("Error " + mex);
}
finally
{
conn.Close();
}
label3.Text = "Importing Records Complete..("+reccount+")";
label3.ForeColor = Color.Blue;
label3.BackColor = Color.White;
label3.Visible = true;
}
