protected void btnImport_Click(Object Sender, EventArgs e) { if (oFile.PostedFile != null && oFile.FileName != "") { oVariables = new Variables(intEnvironment); string strFile = DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString() + "_" + oFile.FileName; oFile.PostedFile.SaveAs(oVariables.UploadsFolder() + strFile); int intNetwork = Int32.Parse(Request.Form[hdnVLAN.UniqueID]); string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + oVariables.UploadsFolder() + strFile + ";Extended Properties=Excel 8.0;"; OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn); DataSet ds = new DataSet(); myCommand.Fill(ds, "ExcelInfo"); foreach (DataRow dr in ds.Tables[0].Rows) { if (dr[0].ToString().Trim() == "") { break; } string strIP = dr[0].ToString().Trim(); string strServer = dr[1].ToString().Trim(); int intIP1 = Int32.Parse(strIP.Substring(0, strIP.IndexOf("."))); strIP = strIP.Substring(strIP.IndexOf(".") + 1); int intIP2 = Int32.Parse(strIP.Substring(0, strIP.IndexOf("."))); strIP = strIP.Substring(strIP.IndexOf(".") + 1); int intIP3 = Int32.Parse(strIP.Substring(0, strIP.IndexOf("."))); strIP = strIP.Substring(strIP.IndexOf(".") + 1); int intIP4 = Int32.Parse(strIP); int intIP = oIPAddresses.Add(intNetwork, intIP1, intIP2, intIP3, intIP4, -100); int intDetail = oIPAddresses.AddDetails("", 0, "", 0, "", strServer, 0, 0, 0, 0, "", "", "", "", 0, 0); oIPAddresses.AddDetail(intIP, intDetail); intCount++; } Response.Redirect(Request.Path + "?done=" + intCount.ToString()); } }