I want to upload excel files from client machine to sql server database at server machine.
When I am using a fileupload control, it is not giving me full path.
Even if I get full path, how can i connect to an excel file which is at client computer, using oledb.
how to get the names of excel files opened on the Client machine and populate it in a ListBox? If somebody did it please reply to this or give some pointers / web site links to me, so that i will read and try to use for building my code.
View 1 RepliesWe have a requirement to allow the cient to upload multiple files which resides in a single folder, within the client computer. To do this can we allow the client to browse for the file location and select a single file (via a normal asp file uploader), and then recursively read the necessary files from the relevant directory? Is this possible or is there any other way to do this?
View 6 RepliesHow to upload the file directly from the client machine. I have one button for mail sending.
If i click the button, the from, to, subject comes using pageload. Like that the default file also could be added as a attachment directly from the client machine.
How to upload the file directly(using file upload control or eithout using file upload control)...
I have developed an application where I need to create a page to read data from Excel File and then update it to the database. The code that I wrote works only when the application runs from my machine. When I deployed the application to the server it gave an error- 'C:PRFileIimport_File.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. here is mu code -
protected void InsertData(object sender, EventArgs e)
{
OleDbConnection oConn = new OleDbConnection
(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\PuertoRicoFile\Puertorico_Iimport_File.xls ; Extended Properties=Excel 8.0 ");
OleDbCommand oCmd = new OleDbCommand("select * from [Puertorico_Data$]", oConn);
oConn.Open(); //Here [Puertorico_Data$] is the name of the sheet in the Excel file where the data is present
OleDbDataReader oleDbReader = oCmd.ExecuteReader();
string AgentIP = "";
string TagName = "";
string Status = "";
string Severity = "";
int EventCount = 0;
string EarliestEvent = "";
string LatestEvent = "";
while (oleDbReader.Read())
{
AgentIP = (string)oleDbReader[0]; // valid(oleDbReader, 0);//Here we are calling the valid method
TagName = (string)oleDbReader[1]; //valid(oleDbReader, 1);
Status = (string)oleDbReader[2]; //valid(oleDbReader, 2);
Severity = (string)oleDbReader[3]; //valid(oleDbReader, 3);
EventCount = Convert.ToInt32(oleDbReader[4]); //oleDbReader[0]; //valid(oleDbReader, 4);
EarliestEvent = (string)oleDbReader[8]; //validate(oleDbReader, 8);
EarliestEvent = EarliestEvent.Substring(0, 19);
LatestEvent = (string)oleDbReader[9]; //validate(oleDbReader, 9);
LatestEvent = EarliestEvent.Substring(0, 19);
InsertDataIntoSql(AgentIP, TagName, Status, Severity, EventCount, EarliestEvent, LatestEvent);
}
SqlConnection mySQLconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["IssNetworkReportingSystemConnString"].ConnectionString);
mySQLconnection.Open();
SqlCommand cmdSql = new SqlCommand("AddMonth_Event_TotalInfo_for_Puertorico", mySQLconnection);
cmdSql.CommandType = CommandType.StoredProcedure;
dbReader = cmdSql.ExecuteReader();
dbReader.Close();
cmdSql = new SqlCommand("AddQtr_Event_TotalInfo_for_Puertorico", mySQLconnection);
cmdSql.CommandType = CommandType.StoredProcedure;
dbReader = cmdSql.ExecuteReader();
dbReader.Close();
oConn.Close();
lblMsg.Text = "Data Imported Sucessfully";
lblMsg.ForeColor = System.Drawing.Color.Green;
}
public void InsertDataIntoSql(string agentIP, string tagName,
string Stat,string severity,int eventCount, string eEvent, string lEvent)
{//inserting data into the Sql Server
SqlConnection mySQLconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["IssNetworkReportingSystemConnString"].ConnectionString);
mySQLconnection.Open();
SqlCommand sqlSelect = new SqlCommand("SELECT SeverityID from Severity where SeverityDesc=@SeverityDesc",mySQLconnection);
sqlSelect.CommandType = CommandType.Text;
sqlSelect.Parameters.Add("@SeverityDesc", SqlDbType.NVarChar).Value = severity;
dbReader = sqlSelect.ExecuteReader();
int severityId = Convert.ToInt32(dbReader.Read());
dbReader.Close();
SqlCommand sqlInsert = new SqlCommand("Insert into IdsData_Puertorico(AgentIP,TagName,Status,SeverityID,EventCount,EarliestEvent,LatestEvent)" +
" values (@AgentIP,@TagName,@Status,@SeverityID,@EventCount,@EarliestEvent,@LatestEvent )" ,mySQLconnection);
sqlInsert.CommandTimeout = 0; //timeout unlimited
sqlInsert.CommandType = CommandType.Text;
sqlInsert.Parameters.Add("@AgentIP", SqlDbType.NVarChar).Value = agentIP;
sqlInsert.Parameters.Add("@TagName", SqlDbType.NVarChar).Value = tagName;
sqlInsert.Parameters.Add("@Status", SqlDbType.NVarChar).Value = Stat;
sqlInsert.Parameters.Add("@SeverityID", SqlDbType.Int).Value = Convert.ToInt32(severityId);
sqlInsert.Parameters.Add("@EventCount", SqlDbType.Int).Value = Convert.ToInt32(eventCount);
sqlInsert.Parameters.Add("@EarliestEvent", SqlDbType.DateTime).Value = DateTime.Parse(eEvent);
sqlInsert.Parameters.Add("@LatestEvent", SqlDbType.DateTime).Value = DateTime.Parse(lEvent);
sqlInsert.CommandType = CommandType.Text;
sqlInsert.ExecuteNonQuery();
mySQLconnection.Close();
}
I want to upload file at client machine using fileupload control. How can I do this in asp.net.. Currently I am using the following code to upload a file. but this code gives the contents of file at server machine..
I need the full file path..In IE versions higher than 7, FileUploadControl.PostedFile.FileName gives only the filename ..
string filename = FileUploadControl.PostedFile.FileName;
sr1 = new StreamReader(FileUploadControl.PostedFile.FileName);
[Code]....
Is there a way we can access image files from client machine in asp.net?
View 1 Replieshow can i get full path of picture by file upload in client machine
View 2 RepliesDownload multiple file from server and stored in client browse directory.
View 1 RepliesI have a Requirement Where I need to Generate the PDf Docuemnts and I need to Send it to the Printer.
All the Pdf Documents are dynamically generated and it will be saved in server Temporary Folder.Then all these PDF Document has to be sent to the Clients Network Printer.
how to download files from server on client machine
View 8 Repliesi need to list client machine Drivers
-> Directories
> Files
using Treeview Control is it possible how to done this
My team working in asp.net projects Here we have to upload Excel contents to Database We are using linq.
View 2 RepliesI have to copy a file from client machine to server folder without use file upload control.
i tried with WebClient().Like this
Dim onbjweb As New WebClient()
onbjweb.UploadFile(Server.MapPath(serverpath), "POST", LocalFilePath).
Its working fine in localhost.When its deployed in server its not working.
I want to access one image file residing in C: of the client's machine. I know with the help of file upload control (or say input type=file), this would be easy. Due to nature of my application (Its a KIOSK application), user is not expected to select file. I am just wondering how should I implement reading file without using file upload control. I want to store this file in Images folder of server. I am beginner to WCF. Should I look towards WCF?
View 7 RepliesMy requirement is to get the file size in client side. there is no problem in FF but in IE you can't do that unless u r using an activeX object. So we thought of putting it in browser cache and reading the file size from there and when we post it to the server we will be taking it from the cache and send it to the server.
View 4 RepliesI have a async file upload control and I am doing client side validation for Image."OnClientuploadstarted" I am doing the client side validation.My validation is working fine but my problem is that the file upload control text box goes green (i.e file is loaded on the server) even if the validation fails which is I dont want.What I want is when the client side validation fails the file does not gets loaded on the server and the Async file upload textbox does not goes green.I have goggled but have not found a suitable solution.
View 4 RepliesWhen calling Response.Cookie.Add(new HttpCookie("MyCookie", "objValue")); where does the cookie saved? on Client Machine or Server Machine?
EDIT:if saved in Client Machine, how can I read it from javascript then? I tried this kind of script.
function getCookie(c_name) {
var i, x, y, ARRcookies = document.cookie.split(";");
for (i = 0; i < ARRcookies.length; i++) {
[code].....
I cannot get the cookie that I saved from code behind. When I look into the document.cookie object, it is just an empty string.
Scenario:On Page_Init() on code behind. I create a cookie using Response.Cookie.Add(new HttpCookie("MyCookie", "cookieValue"));.
On Client side, I'm trying to read the cookie saved from code behind on page load using the snippet above, but it returns undefined
Im using a file uploader to upoad files to a folder used for upload.But the problem is this folder is a linux folder. I have made it a shared folder so that I can access from windows by samba. So, file transfer is successful when I'm using os but when I try to upload something from my websites uploader to this folder, this process is not successful. I have given all permissions to this folder.Don't know whats the problem.I have used both type of slashes for directory but still it is not successful.
View 4 RepliesI am working on asp.net 3.5 through C#, I have 1 problem regarding File Upload. We are using Master Page. How to upload file on Other Machine connected in LAN
View 2 RepliesI am working on VS 2008 on asp.net 3.5.
I have 1 problem regarding file upload.
How to upload file on other Machine folder if it is in LAN .
How to upload file on other Machine folder if it is not in N/W .
how can i access client machine's specific file contained in a drive or folder.Suppose in Server side i have knowledge of full path of a file that is present in client side, like "D:ABCFolderxyzFile.doc", this is a file that i want to retrieve and store in server side .
View 8 RepliesMy project is running with VSS..I have it's IP Address to connect it. There is a folder "DataShare" in VSS for my project. My task is, i need to upload a document(*.doc) from my Local drive to VSS Folder "DataShare" with FileUpload Control How should i do this?
View 2 RepliesI have a web application which is supposed to create a file on clients local mcahine as the user is not having permissions to create a file on the server on which the web application is running.Can anyone please help me with this.I came across some posts stating that it is not a security measure to create a file on clients machine, but in my case I am left with no options.
View 1 RepliesI want to transfer a file from client machine to Web server. I need to allow the users to select a file on their machine and allow them to transfer the file to the web server? Also How does a file control work.
<INPUT
id="File1"
type="file" runat="server">
How to allow the users to transfer files to web servers from their local machine?