I 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#)
How to read a text file and saved in data base
View 1 RepliesI 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 .
i want to display already stored text content (sql server) into asp.net webpage at table format
Now i want to display at table.. alternatively, i want table for gridview. already view at this format. it is gridview..
QaIdQueryAnswer
7
the captain of indian cricket team Mahendra Singh Dhoni
Mahendra Singh Dhoni, commonly known as M. S. Dhoni, is an Indian cricketer and the current captain of the Indian national cricket team and the Chennai Super Kings cricket team. Born: July 7, 1981 (age 31), Ranchi Height: 1.75 m Spouse: Sakshi Dhoni (m. 2010) Salary: 3.5 million USD (2012) Education: DAV Jawahar Vidya Mandir, Shyamali Parents: Pan singh, devki devi.
i 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'm using ASP .NET C# 3.5. I have a multiline textbox on my web form that allows for the input of up to 5,000 characters from the end-user. This text is a basic description of a training course. I need to display it out in a clearly formatted way. For example, I need there to be bullets and bold text.
What I did was I chose certain (not often used) characters and then used the .Replace method when displaying the text in an <asp:Label>. If the text in the database contains the character '~' then I replace that with a line break <br />. If it contains '`' I replace that with <b> and if it contains '^' I replace that with </b>.
Is there a better way of doing this? It is working properly, and I'm displaying the text properly, but I know the end-user is going to hate typing text like this for formatting. I do want this all to stay database driven as well
I have a lot of members data to enter into the ASPNETDB database. How can I read this data from an Access data file and input into the SQL database. All data is for user Names and Password,
View 1 RepliesI have an excel file with data as follows
ID Name Contact No Address
1 ABC XXXXXXX ABCNM2
XYZ xxxxxxx ASDFG
Now my requirement is read data from this excel sheet and den encrypt Contact No field for each row and den save data in database, how should it will be done I have to use some ready made available encryption algo for that.
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 have a DB in which I store Video File Path. Now I want to show that video on my ASP page. especially demo with FlowPlayer.
View 1 RepliesI need to upload book , document and file, that must be stored in a database table. For this I need code.
View 3 RepliesI want use flowplayer to play my flv video file. I have a datalist like below :
<asp:DataList ID="frmViedo" runat="server">
<ItemTemplate>
<div class="flowplayer"> <video>
<source type="video/flv" src='<%# Eval("Vurl" , "~/Videos/Video/{0}") %>'>
</video></div>
</ItemTemplate></asp:DataList>
In code behind :
if (Request.QueryString["vid"] != null) {
frmViedo.DataSource = video.GetVideoById(Convert.ToInt32(Request.QueryString["vid"]));
frmViedo.DataBind();
} public OleDbDataReader GetVideoById(int id) {
string strSelect = "select * from Video where VID = @VID";
return ExecuteReader(CommandType.Text, strSelect, new OleDbParameter[]{
new OleDbParameter("@VID" , id),
}); }
But it don't work and i get this error :
Adobe Flash is disabled for this page, click player area to enable. Why?
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 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 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.
I 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?
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 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 a client who wants to read a text file and then output the contents word by word in a slideshow.
View 7 RepliesI m accessing another application by consuming webservice of that application. I m sending file to store and retrieving file from other dabatase. Web service is the only to access another application.Now, I want to delete the file using the same web service where I stored that file in the another database.I m getting exception and I m unable to figure it out.
View 2 Replieswebsite using text file to store data and display it using html codings. The requested website must be able to do the following functions:
1) Browse for template using txt file and select the txt file as template. (Font-styles, headers, tables....etc)
2) Browse for txt file that stores the data and display them in a so called table format categorized properly.
3) Able to do a search function and store the search results in a new txt file. (Which means a new txt file is created everytime someone performs a search and the search results is stored in the new created txt file)
Is there any website with informations/tutorials on these?
I need to export large (more than 50 lakhs) datatable to a .csv file but i dont know how to code. I am creating a windows service ...
View 1 RepliesI want to know how do you extract values (after the equals sign "=") from a txt file like this, then put the values into a table residing in a database.
channel num = 0
channel State = Active
Working mode = Active
Startup Key = 123456
DTMF = 0118374683
CallerID = 123456
Call direction = Outgoing call
Call Started = 2009/12/22 12:38:45
Call Ended = 2009/12/22 12:38:58
Call Duration = 00:00:12.5000000
I am using file upload mechanism to upload file for an employee and converting it into byte[] and passing it to varBinary(Max) to store into database.
Now I what I have to do is, if any file is already uploaded for employee, simply read it from table and show file name. I have only one column to store a file and which is of type VarBinary. Is it possible to get all file information from VarBinary field?