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 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!)
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 an input type, so a text box which has a browse button next to it. When it is clicked, the file that is selected has it's full path placed into the text box.
<input type="file" runat="server" id="txtFilename" style="width:400px" />
Where is the event! Now that I have the path to the file in the textbox of the input type, I want to load each line of this file into a textbox that is able to handle multiline text. I don't want the file to be uploaded to the website. I just want to contents of the file read and placed in a textbox all with one click on the browse button.
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 have a text file with tab as delimiter. There are about 20 fields in the text file and the file size is about 150MB-200MB.
I need to filter out each row in the textfile based on its field criteria, For Eg: the i should ignore the particular row if the Field A is empty.
I know that by reading out the text file row by row it will be certainly slow.
how to read out the text file fast and also how to do the file processing for the read out text file?
I want to read and write a txt file but
The process cannot access the file 'D:BelgelerimVisual Studio 2005WebSitesmacrotechCounter.txt' because it is being used by another process.
what is wrong with this
StreamWriter FileWriter;
StreamReader FileReader;
string Countstr;
string str1;
int Len1,i;
FileReader = File.OpenText(Server.MapPath(Page.ResolveUrl("~/Counter.txt")));
FileReader = File.OpenText(Server.MapPath("~/Counter.txt"));
Countstr = FileReader.ReadLine();
FileReader.Close();
FileReader.Dispose();
i = Convert.ToInt32(Countstr) + 1;
Countstr = Convert.ToString(i);
FileWriter = File.CreateText(Server.MapPath("~/Counter.txt"));
FileWriter.WriteLine(Countstr);
FileWriter.Close();
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 have some code in my default.apsx.cs file that all works except one very small but important piece.. I have the same code in c# consoleapp and it works fine on my local machine.
Here is the code...
[code]...
When i try and run it through visual web developer it seems to feel the file doesnt exits so evaluates the if statement to false and moves. on... I havent specified a path and have the file in the same folder as the default.aspx.cs file.
How to read a text file and saved in data base
View 1 RepliesI have a txt file, in which read only property is true. When I try to write some text in that file through the vb coding, it's through the error. I have shown the code below.
Dim fs As FileStream = File.OpenWrite(HttpContext.Current.Server.MapPath("Include/CacheKeyFile.txt"))
Dim sw As New StreamWriter(fs)
sw.Write("Menu setup updated by " & value & " on " & DateTime.Now.ToString())
sw.Close()
fs.Close()
I found the cause of the error. If we set the Write access property to false, we can open the file and write it without showing the error messages.
I need to remove the Read only property for a file through the vb. Net code. Is it possible? Can we set the read only for txt file before open and write operation?
I want to read a text file and separate the data and write it back to another text file. So the input file content is like 07090000079011110225000 00001000100010118832 032111050111205011110501111022500000FL .... I know that first 3 characters are for CompanyID, next 2 are for Symbol etc. How Can I put it together? I used to write in VB code like this below using a Type and define the width there.(easy to maintain) How can I do that in VB.Net or c#?
[Code]....
So the output will be like CompanyID : 070 Symbol :90 .
How do I read/write a text file on another server from a web page.I get the error "Access to the path '//Server2/mydatafiles/test.txt' is denied". I do not get the error if I am running the browser on the server where the files exist.I think I need to set permissions on the destination server in some way.
View 4 RepliesI have a text file stored in my sql DB. in that .txt file I have certain numbers like:
99435
87889
33455
33555
34556
How to get the count of these numbers from the txtfile stored in the database? Also to read the file and fetch the number one by one in a string? I am using asp.net (C#)
I have a client who wants to read a text file and then output the contents word by word in a slideshow.
View 7 Replieshow to make any text file on the client computer ?
can i get any C# asp.net sample code ?
how to make any text file on the client computer ?can i get any C# asp.net sample code ?
View 4 RepliesI need to save a text file on the client side possibly without permission. The case is that I need to save this text file in a shared folder in this or in another machine in the lan. This text file is going to be read automatically by the fiscal printer which will print the fiscal invoice. I have a asp .net web application and the server is not on the same lan with the fiscal printer, so I have to write it on the client-side. how to do this without asking to the user every time for the security issue.
I can accept a solution like, the client is asked only one time a the first printing, but not every time he wants to print a bill. Some kind of asking permission to the client for allowing this website, in order to not repeat the permission asking.
In ASP.Net, I want to give a user an ability to save the text entered in the textbox to the client machine. So that, user can copy paste it for later use.
Is there a way to show, save as dialog so that user can save the text in a text file on client machine? or, if there is any other alternative?
How to read character by character in line from text file?
View 1 Repliesi am having my text file data as follows
101011111111101111111111007060540A0941
I would like read this data and place it to the Corresponding cell in data grid.
I 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 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();
}