yes i was loading something on the server. Here is the Code
Code:
protected void btnImport_Click(object sender, EventArgs e)
{
//Check the Filetype
String sFiletype;
String sFinename = FileUploadTimetable.FileName;
sFiletype = Path.GetExtension(sFinename);
sFiletype = sFiletype.ToLower();
Boolean Check_Bool = Check_Rules_Before_Upload(sFiletype, FileUploadTimetable);
if (Check_Bool == false)
{
lblStatus.Text = "Please upload a file first.";
}
else
{
string xml = string.Empty;
if ((FileUploadTimetable.PostedFile != null) && (FileUploadTimetable.PostedFile.ContentLength > 0))
{
string SaveLocation = Server.MapPath("App_Data") + "\\" + Path.GetFileName(FileUploadTimetable.PostedFile.FileName);
//string xmlFn = Server.MapPath("App_Data") + "\\" + Path.GetFileNameWithoutExtension(FileUpload.PostedFile.FileName) + ".xml";
try
{
FileUploadTimetable.PostedFile.SaveAs(SaveLocation);
StreamReader sr = new StreamReader(SaveLocation);
xml = sr.ReadToEnd();
sr.Close();
lblStatus.Text = CommonFunctions.ExecuteStoredProc("dbo.import_Timetable_Data '" + xml + "'");
this.CreatePopUpWindow("TimetablePopUpWindow", "TimetableImportReport.aspx"); // create a popup window at starttime
File.Delete(SaveLocation);
}
catch { }
}
else
{
lblStatus.Text = "The uploaded file is empty.";
}
}
}
Thanks