conString = string.Format(conString, excelPath);
using (OleDbConnection excel_con = new OleDbConnection(conString))
{
excel_con.Open();
string sheet1 = excel_con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null).Rows[0]["TABLE_NAME"].ToString();
DataTable dtExcelData = new DataTable();
dtExcelData.Columns.AddRange(new DataColumn[2]
{
new DataColumn("Id", typeof(int)),
new DataColumn("Name", typeof(string)) });
using (OleDbDataAdapter oda = new OleDbDataAdapter("SELECT * FROM [" + sheet1 + "]", excel_con))
{
oda.Fill(dtExcelData);
}
excel_con.Close();
string consString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
using (SqlConnection con = new SqlConnection(consString))
{
using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
{
if (dtExcelData.Rows.Count > 0)
{
foreach (DataRow dRow in dtExcelData.Rows)
{
objContactBO.id = dRow["id"].ToString();
objContactBO.Name = dRow["Name"].ToString();
string strValue = objContactBO.Name;
string[] strArray = strValue.Split(',');
foreach (String Name in strArray)
{
objContactBO.Name = dt.Rows[0]["Name"].ToString();
result2 = objContactBL.Insert_ContactInDiffColumName(objContactBO);
}
}
}
}
}
}