hi,
i am uploading .doc,.docX,rtf files during registration level and that path can be saved in database(i am using database MYSQL).when user want to see his resume he/she can login and retrive his details by clicking on retrive button.my problem is the code will be working in local system it not working in server.i am attaching my code shown below - using System;
-
using System.Data;
-
using System.Configuration;
-
using System.Collections;
-
using System.Web;
-
using System.Web.Security;
-
using System.Web.UI;
-
using System.Web.UI.WebControls;
-
using System.Web.UI.WebControls.WebParts;
-
using System.Web.UI.HtmlControls;
-
using Microsoft.Office.Interop;
-
using System.IO;
-
using System.Reflection;
-
-
#endregion
-
-
public partial class ResUploadOrCompDesc : System.Web.UI.Page
-
{
-
#region "Global Variables "
-
-
DataAccess ObjDA;
-
-
#endregion
-
-
#region "Page_Load "
-
-
protected void Page_Load(object sender, EventArgs e)
-
{
-
try
-
{
-
string UName = "";
-
string TblType = "";
-
ObjDA = new DataAccess();
-
lblErrMsg.Text = "";
-
-
if (!IsPostBack)
-
{
-
Session["MyAccount"] = "false";
-
if (Session["UserName"] == null)
-
Response.Redirect("Home.aspx");
-
else
-
{
-
UName = Session["UserName"].ToString();
-
-
if (Session["TblType"] != null)
-
TblType = Session["TblType"].ToString();
-
-
Session["MyPhoto"] = "~/UserPhotos/" + UName + @"\" + ObjDA.GetScalarValues(TblType + "MyAcc", "", "username='" + UName + "'");
-
-
if (TblType == "PRD4")
-
{
-
imgbtnGetResInfo.Visible = false;
-
fudResume.Visible = false;
-
lblUpload.Visible = false;
-
lblValMsg.Visible = false;
-
txtResume.Text = ObjDA.GetScalarValues(TblType, "compdesc", "username='" + UName + "'");
-
}
-
else
-
{
-
imgbtnGetResInfo.Visible = true;
-
fudResume.Visible = true;
-
lblUpload.Visible = true;
-
lblValMsg.Visible = true;
-
}
-
//if (IsPostBack)
-
//{
-
// if (Request.Form["hid_f"] == "1") //if user clicks "OK" to confirm
-
// {
-
// int i = 0;
-
// Request.Form["hid_f"].Replace("1", "0");
-
// i = ObjDA.InsertOrUpdateOrDeleteData(TblType, "", UName, "D");
-
// ObjDA.InsertOrUpdateOrDeleteData("Ref", "", Session["a"].ToString(), "D");
-
// if (i == 1)
-
// {
-
// MsgBox1.alert("Account deleted sucessfully");
-
// Response.Redirect("home.aspx");
-
// }
-
// else
-
// {
-
// MsgBox1.alert("Unable to delete the selected record and try again");
-
// }
-
// }
-
//}
-
}
-
}
-
}
-
catch (Exception ex)
-
{
-
lblErrMsg.Text = ex.Message;
-
}
-
finally
-
{
-
if (ObjDA != null)
-
ObjDA = null;
-
}
-
}
-
-
#endregion
-
-
#region "imgbtnGetResInfo_Click "
-
-
protected void imgbtnGetResInfo_Click(object sender, ImageClickEventArgs e)
-
{
-
try
-
{
-
string UName = "";
-
string TblType = "";
-
string ResumeFilePath = "";
-
ObjDA = new DataAccess();
-
-
if (Session["UserName"] != null)
-
UName = Session["UserName"].ToString();
-
if (Session["TblType"] != null)
-
TblType = Session["TblType"].ToString();
-
-
//Request.Form["hid_f"].Replace("1", "0");
-
-
ResumeFilePath = AppDomain.CurrentDomain.BaseDirectory + @"UserResumes\" + UName + "\\" + ObjDA.GetScalarValues(TblType, "resume", "UserName='" + UName + "'");
-
-
if (File.Exists(ResumeFilePath))
-
{
-
Microsoft.Office.Interop.Word.ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();
-
object FileName = ResumeFilePath;
-
object nullobj = System.Reflection.Missing.Value;
-
Microsoft.Office.Interop.Word.Document DocOne = wordApp.Documents.Open(ref FileName, ref nullobj, ref nullobj,
-
ref nullobj, ref nullobj, ref nullobj,
-
ref nullobj, ref nullobj, ref nullobj,
-
ref nullobj, ref nullobj, ref nullobj,
-
ref nullobj, ref nullobj, ref nullobj, ref nullobj);
-
-
Microsoft.Office.Interop.Word.Document DocTwo = wordApp.ActiveDocument;
-
txtResume.Text = DocTwo.Content.Text;
-
DocOne.Close(ref nullobj, ref nullobj, ref nullobj);
-
}
-
else
-
{
-
lblErrMsg.Text = "No File Uploaded";
-
}
-
}
-
catch (Exception ex)
-
{
-
lblErrMsg.Text = ex.Message;
-
}
-
finally
-
{
-
if (ObjDA != null)
-
ObjDA = null;
-
}
-
}
-
-
#endregion
-
-
#region "imgbtnUpdateResume_Click "
-
-
protected void imgbtnUpdateResume_Click(object sender, ImageClickEventArgs e)
-
{
-
try
-
{
-
int FilesCount = 0;
-
string UName = "";
-
string TblType = "";
-
string DirName = "";
-
int i = 0;
-
ObjDA = new DataAccess();
-
-
if (Session["UserName"] != null)
-
UName = Session["UserName"].ToString();
-
if (Session["TblType"] != null)
-
TblType = Session["TblType"].ToString();
-
-
DirName = AppDomain.CurrentDomain.BaseDirectory + @"UserResumes\" + UName;
-
-
if (imgbtnGetResInfo.Visible == true)
-
{
-
if (Directory.Exists(DirName) == false)
-
Directory.CreateDirectory(DirName);
-
else
-
{
-
FilesCount = Directory.GetFiles(DirName).Length;
-
if (FilesCount > 0)
-
{
-
for (int j = 0; j < FilesCount; j++)
-
{
-
if (File.Exists(Directory.GetFiles(DirName)[j].ToString()))
-
File.Delete(Directory.GetFiles(DirName)[j].ToString());
-
}
-
}
-
}
-
-
fudResume.SaveAs(DirName + @"\" + fudResume.FileName.ToString());
-
-
ObjDA.InsertOrUpdateOrDeleteData(TblType, "resume=''", "UserName='" + UName + "'", "U");
-
i = ObjDA.InsertOrUpdateOrDeleteData(TblType, "resume='" + fudResume.FileName.ToString() + "'", "UserName='" + UName + "'", "U");
-
-
if (i == 1)
-
{
-
lblErrMsg.Text = "Resume uploaded successfully";
-
txtResume.Text = "";
-
}
-
}
-
else
-
{
-
ObjDA.InsertOrUpdateOrDeleteData(TblType, "compdesc=''", "UserName='" + UName + "'", "U");
-
i = ObjDA.InsertOrUpdateOrDeleteData(TblType, "compdesc='" + txtResume.Text + "'", "UserName='" + UName + "'", "U");
-
if (i == 1)
-
lblErrMsg.Text = "Company Description updated successfully";
-
}
-
-
}
-
catch (Exception ex)
-
{
-
lblErrMsg.Text = ex.Message;
-
}
-
finally
-
{
-
}
-
}
-
-
#endregion
-
(***here is no server problem*****)can any one help me plzzzz
3 2899
hi,
i am uploading resume in registration levels.the user want to see his/her resume he/she can login and click on 'getresume' button all the information could be displayed in multiline text box.my problem is it will be working on local system when we are hosting the resume will not be displayed. i am using my sql database.my code will be shown below -
#region "imgbtnGetResInfo_Click "
-
-
protected void imgbtnGetResInfo_Click(object sender, ImageClickEventArgs e)
-
{
-
try
-
{
-
string UName = "";
-
string TblType = "";
-
string ResumeFilePath = "";
-
ObjDA = new DataAccess();
-
-
if (Session["UserName"] != null)
-
UName = Session["UserName"].ToString();
-
if (Session["TblType"] != null)
-
TblType = Session["TblType"].ToString();
-
-
//Request.Form["hid_f"].Replace("1", "0");
-
-
ResumeFilePath = AppDomain.CurrentDomain.BaseDirectory + @"UserResumes\" + UName + "\\" + ObjDA.GetScalarValues(TblType, "resume", "UserName='" + UName + "'");
-
-
if (File.Exists(ResumeFilePath))
-
{
-
Microsoft.Office.Interop.Word.ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();
-
object FileName = ResumeFilePath;
-
object nullobj = System.Reflection.Missing.Value;
-
Microsoft.Office.Interop.Word.Document DocOne = wordApp.Documents.Open(ref FileName, ref nullobj, ref nullobj,
-
ref nullobj, ref nullobj, ref nullobj,
-
ref nullobj, ref nullobj, ref nullobj,
-
ref nullobj, ref nullobj, ref nullobj,
-
ref nullobj, ref nullobj, ref nullobj, ref nullobj);
-
-
Microsoft.Office.Interop.Word.Document DocTwo = wordApp.ActiveDocument;
-
txtResume.Text = DocTwo.Content.Text;
-
DocOne.Close(ref nullobj, ref nullobj, ref nullobj);
-
}
-
else
-
{
-
lblErrMsg.Text = "No File Uploaded";
-
}
-
}
-
catch (Exception ex)
-
{
-
lblErrMsg.Text = ex.Message;
-
}
-
finally
-
{
-
if (ObjDA != null)
-
ObjDA = null;
-
}
-
}
-
-
#endregion
-
-
#region "imgbtnUpdateResume_Click "
-
-
protected void imgbtnUpdateResume_Click(object sender, ImageClickEventArgs e)
-
{
-
try
-
{
-
int FilesCount = 0;
-
string UName = "";
-
string TblType = "";
-
string DirName = "";
-
int i = 0;
-
ObjDA = new DataAccess();
-
-
if (Session["UserName"] != null)
-
UName = Session["UserName"].ToString();
-
if (Session["TblType"] != null)
-
TblType = Session["TblType"].ToString();
-
-
DirName = AppDomain.CurrentDomain.BaseDirectory + @"UserResumes\" + UName;
-
-
if (imgbtnGetResInfo.Visible == true)
-
{
-
if (Directory.Exists(DirName) == false)
-
Directory.CreateDirectory(DirName);
-
else
-
{
-
FilesCount = Directory.GetFiles(DirName).Length;
-
if (FilesCount > 0)
-
{
-
for (int j = 0; j < FilesCount; j++)
-
{
-
if (File.Exists(Directory.GetFiles(DirName)[j].ToString()))
-
File.Delete(Directory.GetFiles(DirName)[j].ToString());
-
}
-
}
-
}
-
-
fudResume.SaveAs(DirName + @"\" + fudResume.FileName.ToString());
-
-
ObjDA.InsertOrUpdateOrDeleteData(TblType, "resume=''", "UserName='" + UName + "'", "U");
-
i = ObjDA.InsertOrUpdateOrDeleteData(TblType, "resume='" + fudResume.FileName.ToString() + "'", "UserName='" + UName + "'", "U");
-
-
if (i == 1)
-
{
-
lblErrMsg.Text = "Resume uploaded successfully";
-
txtResume.Text = "";
-
}
-
}
-
else
-
{
-
ObjDA.InsertOrUpdateOrDeleteData(TblType, "compdesc=''", "UserName='" + UName + "'", "U");
-
i = ObjDA.InsertOrUpdateOrDeleteData(TblType, "compdesc='" + txtResume.Text + "'", "UserName='" + UName + "'", "U");
-
if (i == 1)
-
lblErrMsg.Text = "Company Description updated successfully";
-
}
-
-
}
-
catch (Exception ex)
-
{
-
lblErrMsg.Text = ex.Message;
-
}
-
finally
-
{
-
}
-
}
-
(****there is no server problem its working fine***)
can any one help me plz
Hi,
If the application is working in localhost but not on webserver there can be these possibilites in my opinion:
1. You have not given access to read/write to the UserResumes directory. So the application is failing for writing the given resume.
2. Your Office components are not properly installed on the server.
Try to eliminate the above two. As far as I know, if server is working fine, client should not have any problem.
What do you mean when you say your code is "not working" on the web server?
Is your website working but you are not able to upload files?
What is the error you are getting when you attempt to run the site on the web server?
If you have access to the web server, check the Windows Event Logs for any error messages generated by ASP.NET and please post them so that we have an idea of what's going on.
Do you have ASP.NET installed on the web server?
Is your web server configured to run your site with the same .NET Framework that your application was developed with?
Do you have all permissions set correctly?
Sign in to post your reply or Sign up for a free account.
Similar topics
by: jason |
last post by:
Is there a way to avoid On Error Resume Next for:
cnn.Open strCon
SQL = "EXEC Customer @txtEmail='" & email_address & "'"
set rs = cnn.execute(SQL)
'On error resume next
rs("email_address")...
|
by: Ian DeRock |
last post by:
I'm fairly new to XML. As I can see it, XML is a way to organize data
like in a table in a RDB, or the RDB itself. I have used XML in
application data, but did not design the actual XML.
I...
|
by: Darta |
last post by:
OK- I volunteer to be shot if this question is stupid... BUT, is there
a way to, when you catch an exception in the catch{} handler, resume
to the same line of code that generated an error while...
|
by: juky |
last post by:
Hi all,
I have a loop in the thread checking for a particular service status,
whenever the status changes to "stopped" a RaiseEvent is generated by
thread and another function runs. At the same...
|
by: bob.needler |
last post by:
I know On Error Resume Next is generally considered lazy. But can
someone tell me why the resume next in Exit_Handler does not seem to
work? It generates the typical unhandled runtime error...
|
by: fniles |
last post by:
In VB 6.0 in the error trapping, we can do "resume next" to continue on the
next code. How can we do that in .NET with "Try", "Catch","End Try" ?
Thanks
|
by: Neo |
last post by:
I found on error resume next doesn't work in for each... e.g.
on error resume next
for each x in y
'do stuff
next
if you have an error in for each loop, it falls in infinite loop... it...
|
by: Maxwell2006 |
last post by:
Hi,
I know that this is not a good practice, but I wonder do we have "on error
resume next" in C#?
Thanks,
|
by: MMcCarthy |
last post by:
Organizing a Resume
Pertinent information included on your resume may be organized in a variety of ways. Regardless of the type of resume used, you should include the following:
Contact...
|
by: MeoLessi9 |
last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: Aftab Ahmad |
last post by:
Hello Experts!
I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
|
by: Aftab Ahmad |
last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below.
Dim IE As Object
Set IE =...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: marcoviolo |
last post by:
Dear all,
I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
| |