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 RepliesI 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.
I'm populating a generic list from an excel file that contains names of pdf files. Now I want to take each item in the list and create a file from it. Here's what I have so far:
[Code]....
So now, the list called lines contains names of 900 pdf files. How would I take those names out of the list and create files from them?
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();
}
Is there a way we can access image files from client machine in asp.net?
View 1 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
I have an asp.net application, which opens an excel file and reads it content. If user closes the application or the page when the excel file reading in progress, i want to kill the Excel process (which is opened by the current instance.
View 17 RepliesI have an ASP.Net project created by a team member on another computer. The project references a virtual directory that exists on my computer but under a different localhost location.Currently, the following error occurs when I try to open the project:
The local IIS URL http://localhost/foo/default.aspx specified for Web project foobar has not been configured. In order to open this project the virtual directory needs to be configured. Would you like to create the virtual directory now?[Yes] [No]
So, there are two options: select yes: It creates the virtual directory that it thinks I need, which I don't want to do. I already have a virtual directory somewhere else.
select no: This isn't an option, as the project opens, but without all the bells and whistles I know and love.
Where is the virtual directory location (in my case http://localhost/foo/default.aspx) specified within the project? Can I change this manually, say in a configuration file within the project, either before or after I open it? A configuration change seems more ideal than manually opening IIS to override a virtual directory path.
EDIT (solution): Buried in the comments below is the following answer (Thanks @Thyamine)This can be configured in the foo.csproj file for the project. Look for the lines:
<ProjectExtensions>
<VisualStudio>
<FlavorProperties GUID="{F00-000-000}"> [code]....
[Code]....
The dilaogbox that offers me to save the file shows incorrect chars if documentFileName has name not in ASCII format. What I'm supposed to do to have the file name displayed correctly in this dialogbox and to have this file opened under the same name in MS Word, Excel whatever else?
I tried to use a DropDown-Control (WebDropdown from Infragistics) for the following function: Let the user enter any text or if he wishes choosing by a context menu two different "Already exist entries" in the DropDown-List from where he can choose a value. The behaviour should be this for the DropDown: Right-clicking on the DropDown-Control, filling the DropDownList in the server depending on the choosen context menu item, opening the DropDownList in the client.
The way I tried to solve:
Open (by javascript) a context menu by right clicking on the control
[Code]....
What's the problem? The problem is, that the above javascript function does find the WebDropDown1 control only if it is called client side (e.g. with a OnClientClick button event), calling it from server side (as in the ContextMenu_ItemClick subroutine) it does not find the WebDropDown1 control. The error is shown (translated into english): run time error: object expected.
Maybe a completly different solution is necessary as I transfer a windows forms program into a web form ajax style program. I could use a textbox with dropdownextender for example. But the problem seems to be always the same: uncoupling the dropdown function, which is a client side one, by first filling the dropdownlist on server side, and then invoking the dropdown event makes the problem.
I am having list of records to insert in the sql. For that i need to get the sheet name.
How to get the sheet name of the excell in code behind.
When 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
I'm building an app that allows multiple file upload (trying to use the script from here: [URL] This upload will be a pop up from an html page. My question is how to pass the file name(s) to the parent page? I want to submit those names as hidden inputs from the html page.
View 8 RepliesI'd like give unique name for uploaded files in a folder.
I know we can a uniqueidentifier to file name but I think it isn't a good way.
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 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 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?
I am developing a Web Application using ASP.NET(C#.NET). One of the critical requirements of it is Print Word/Pdf Documents on Client Side i.e.., Print to printer connected to a Client Machine. I have searched a lot for this and i didn't got it solved..
Now i got a thought of developing a windows application associated with web App. And i want to create a plugin for winApp in WebApp. Is it possible, if yes then how to develop a plugin using .NET for Web Application.
How 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 am creating a web application using Asp.Net3.5. I tried to copy file from one location (some folder on the deployed to server ) to another machine (on the same network) , both the machine is running Windows Vista. It works fine, But when i tried to copy the same set of files to another machine ( MAC ) on same network it is not allowing. So how to achieve this functionality. Sample code for reference
[Code]....
im trying to read column names from excel .
View 3 Replies