protected void Button1_Click(object sender, EventArgs e)
{
string fileName = FileUpload1.ResolveClientUrl(FileUpload1.PostedFile.FileName);
int count = 0;
StudentOrganizationDBClassDataContext dataContext = new StudentOrganizationDBClassDataContext();
try
{
DataTable dtExcel = new DataTable();
string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + fileName + "';Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'";
OleDbConnection con = new OleDbConnection(SourceConstr);
string query = "Select * from [Sheet1$]";
OleDbDataAdapter data = new OleDbDataAdapter(query, con);
data.Fill(dtExcel);
for (int i = 1; i < dtExcel.Rows.Count; i++)
{
try
{
string lastName = dtExcel.Rows[i][1].ToString();
string firstName = dtExcel.Rows[i][0].ToString();
string email = dtExcel.Rows[i][2].ToString();
string phoneNumber = dtExcel.Rows[i][3].ToString();
bool offCampus;
if (dtExcel.Rows[i][4].ToString() == "0")
{
offCampus = false;
}
else
{
offCampus = true;
}
//count += dataContext.sp_NewAdvisor(lastName, firstName, email, phoneNumber, offCampus);
//dataContext.SubmitChanges();
}
catch (Exception ex)
{
continue;
}
}
if (count == dtExcel.Rows.Count)
{
lblMessage.Text = "Success";
}
else
{
lblMessage.Text = "failure";
}
}
catch (Exception ex)
{
throw ex;
}
}