How can I read a file from client's pc? I found out that it required to upload the file to server and read it from the server, what if I want to read it directly from client's pc, can I do that
View 4 RepliesI 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 have to read a client side ini file in Aspx page and use that data in server side processing. refer to a link or any sample if possible.
View 6 RepliesI have to read the first couple of lines of a csv file client side to present the user with a preview before uploading a large file.
I'm using c# with ASP.Net (VS2010)
Does anyone know how this can be done? Also that it works in all browsers!?!
(It's not possible to use activeX or so, we do not want our clients to install something!)
I have a project of ASP.NET which is a Customer satisfaction Survey, i need to to incorporate the option selected by customer with the a client side text file which i located at the client machine, read a text file on client or should i develop the survey application as window application.
View 7 RepliesI would like ask you for some ideas how can I write mechanism that will be automatically read files from folder. I don't know how to schedule the write task. I want to check for new file everyday and if the new file is in the folder read it.
View 2 RepliesI have a treeview which showcheckbox=true, when the checkbox is ticked I need to run a js function on client side and read the value of the checkbox
I set the treeNode1.value=i
In IE, I can get the value of each check box (which is i...)
but in chrome, firefox and safari, the value is always "On"
I set debug=true in web.config file but once app got error only display general error message. I have to run app in web server to get error detail.
How to make error detail in client site so that I can read error detail?
I set debug=true in web.config file but once app got error only display general error message. I have to run app in web server to get error detail.
How to make error detail in client site so that I can read error detail?
Anyone know of a way to read out in a list all of the UpdatePanel Client ID's I have on a page? Basically I need to loop through all controls in the page with a type of UpdatePanel, and display the ClientID for each..
I have four update panels on this page and I am using this
private string LoopUpdatePanel(ControlCollection controlCollection)
{
StringBuilder sb = new StringBuilder();
foreach (Control control in controlCollection)
{
if (control is UpdatePanel)
{
sb.Append(((UpdatePanel)control).ClientID + ", ");
}
if (control.Controls != null)
{
LoopUpdatePanel(control.Controls);
}
}
return sb.ToString();
}
is this c# code intended to read local client files?System.IO.FileStream content = System.IO.File.Open("c: est.txt", System.IO.FileMode.Open);It gives me error FILE NOT FOUND
View 2 RepliesI've read that OnClick is executed on the server and onClientClick is executed on the client. Is it better to use OnClientClick to do something like close a modal popup?
If my understanding is correct then this would avoid a trip to the server to accomplish the same task. This would be great for something that doesn't need to make a round trip to the server and back.
I used PopupControl Extender to display row details from a gridview, and need to update the two textboxes, but the changed value in the textboxes did not get picked up when click the update button on the popup window, so I need to get client side javascript to read the new changed value from these text boxes. However, I tried a few way, none worked for me, not sure what is wrong.
1. Add a javascript function in the .aspx file and use onclientclick of the linkbutton control to call the function, I got error of "Microsoft JScript runtime error: Object required".
<script language="javascript" type="text/javascript">
function newTextValue(textbox)
{
var text = document.getElementById("TextBox1").Value;
alert(text);
}
</script)
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("GalleryTemplateName") %>' Height="20px" Width="230px"
style="text-align: left"></asp:TextBox>
<asp:LinkButton ID="LinkButton2" runat="server" Font-Bold="True" CommandArgument='<%# Eval("GalleryTemplateId") %>'
oncommand="LinkButton2_Click" OnClientClick="newTextValue(this)" >Update</asp:LinkButton>
2. Use ScriptManager.RegisterClientScriptBlock in the aspx.cs file, :
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "changevalue", "alert(document.getElementById('TextBox1').value);", true);
but the alert window did not showup, that means the client javascript did not run? I just use an alert window to test to see if the textbox value is picked up. Note, I used Ajax Toolkit PopupControl Extender, all codes are in an update panel.
i want to read a pdf file i am using code
using org.pdfbox.pdmodel;
using org.pdfbox.util;
PDDocument doc = PDDocument.load("C:\Documents and Settings\mohit.tiwari\English.pdf");
PDFTextStripper pdfstripper = new PDFTextStripper();
TextBox1.Text = pdfstripper.getText(doc);
Error:Could not find file 'C:Documents and Settingsmohit.tiwariEnglish'
i am giving right path still it is giving the same problem.
How can i Read pdf in zip file in asp.net 2.0?
View 10 RepliesI want to read file js from other web site in code behide, How do I make It? This is link : [URL] I only know code load file js from my PC!
[Code]....
How to read .db file i added namespace " using System.Data.SQLite;" and
string path=@"c:xxxyyydalitelocal.db";
string myConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=Paradox 5.x;";
how to read contents of path file.
I found some code that looks like it will do what I want to do, but the code doesn't work.
[Code]....
The error seems to occur here: mytext.txt
Error Message is: unrecognized escape sequence
I think somehow the syntax with StreamReader is not quite right.
I did something similar in VB and it worked fine. I'm just beginning to learn C#; it's going to be a little while before the training wheels come off.
i am using below code for reading the csv fie..by using this code, it's reading the csv file first line onwards, but i want to read the csv file from 2nd line onwards
below am displaying the code
[Code]....
How to read the zip file content in C# without using Third party component, only i have to use existing C# classes.
For Example,
Test.zip file contain Sample1.txt,Sample2.pdf,Sample3.doc file in it, i want to read the files name within the test.zip file in C#,
Im trying to open and read a file from the LAN at \192.168.2.24\foldersalida.txt using a windows services, coded in C#
I tried to check if the file exists using FileExists and it returns false.
When I tried to open it, it throw an exception
I have a zip file, I want to check the folders and files inside it but I do not want to unzip it because it maybe large, is it possible to do that?
View 2 RepliesI would like to use HTML input file type in my aspx page to allow user to browse for a excel file and then read the content of the excel sheet programmatically.If I want to read the excel sheet I need the full path of the file to connect to the excel sheet using asp.net.I do not understand how can I get the full path of the file.I know I can get the filename using postedFile.FileName property.But I need the full path of the file.
View 2 RepliesI have created an excel sheet from datatable using function. I want to read the excel sheet programatically using the below connectionstring. This string works fine for all other excel sheets but not for the one i created using the function. I guess it is because of excel version problem.
OleDbConnection conn= new OleDbConnection("Data Source='" + path +"';provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;";);
which i can create an excel sheet such that it is readable again using above query. I cannot use Microsoft InterOp library as it is not supported by my host. I have even changed different encoding formats. Still it doesnt work
[code]....
I must to read table in html file. I'm try to read html table to data set and xml but it dosen't work. Anyone have any solution to read table or entity control in html file.
View 4 Replies