How to create Text file while reading from database?
DataBase Table has 10 records in it
ID Name Age
1 Jon 18
2 Martin 20
..
..
10 Andy 30
I want create a text file like this
ID: 1
Name: Jon
Age: 18
-----------------
ID: 2
Name: Martin
Age: 20
-----------------
ID: 10
Name: Andy
Age: 30
I have written the following ocde to save the data in to textfile.
using(TextWriter tw=new StreamWriter(file))
{
string refcode = txtReftypecode.Text;
tw.Write(refcode.PadLeft(1,'0'));
string priorcode = txtPrioritycode.Text;
tw.Write(priorcode.PadLeft(2, '0'));
tw.Write(txtImmediateddest.Text.PadLeft(2,'0'));
tw.Write(txtImmediateorg.Text.PadLeft(10,'0'));
string date=txtFilecreatdate.Text.Replace("/","");
tw.Write(date.PadLeft(6,'0'));
string time1=txtFilecreattime.Text.Replace(":","");
tw.Write(time1.PadLeft(4,'0'));
tw.Write(txtFileIDmodifier.Text);
tw.Write(txtRecsize.Text.PadLeft(3,'0'));
tw.Write(txtBlockingfac.Text.PadLeft(2,'0'));
tw.Write(txtFormatcode.Text.PadLeft(1,'0'));
tw.Write(txtImmeddestname.Text.PadRight(23,' '));
tw.Write(txtImmedorgname.Text.PadRight(23,' '));
tw.Write(txtRefcode.Text.PadRight(8,' '));
tw.WriteLine();
}
Now i would like to represent the data in to the corresponding to text boxes when i open that text file.
I 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.
im currently trying to create a blog using c# and xml. ive created the form and code that allows me to write the data inputted to an xml form and now i want to display it in another page. can anyone tell me what to do?
View 4 RepliesI'm trying to read the contents of a text file into a text box on my form. When I run the following code, nothing happens.
VB.NET Code:
Protected Sub lbLogs_SelectedIndexChanged(ByVal sender As Object,
ByVal e As EventArgs) Handles lbLogs.SelectedIndexChanged
For Each li As ListItem In lbLogs.Items
If li.Selected Then Using sw As New StreamReader(li.Value)
txtLog.Text = sw.ReadToEnd sw.Close() End Using End If Next End Sub
I populate the ListBox with ListItems and each ListItem's Value property holds the full path to the file. But, I removed all of that and just put txtLog.Text = "test" inside of the "is selected" block.
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 have the following data that basically I only need a few bits of information from: The only things I need from this are:
Patients Name
Drs Name
Patients Phone Number
Appt Time
Appt Date
and the rest of the information I can discard. A customer uploads this as a .csv file (even though it really isn't as you can see) and I'd like to parse the needed information and post that to my SQL database and discard the rest. I think I can do this with a dataset but I've never built that before. The fields from the customer will always be the same and the fields I will need will always be the same. Also, the date time has to be in the format of yyyy/mm/dd:hhmm and the phone number always has to have 512 as a prefix. Here is the code I currently have for my site:
[Code]....
I'm trying to read data from a text file into a DataReader object using the following code but I get an exception:
OleDBException was unhandled.
Cannot update. Database or object is read-only.
Also, I would like to know if it is efficient to read data of a text file into a datatable instead of using StreamReader object and traversing through the recordset.
[Code]....
i like to create a web application,in that i need to get the resumes from the user,then i need to publish that resume to the manager in date wise..
View 5 RepliesI am trying to populate database fields by reading text from a Word or PDF document. Like if a user uploads a file then certain text from that file can be usd to populate a database table.
View 1 Repliesi'm using a little javascript in my website for my navigation bar, which is made up of a few ImageButton controls. in the code behind i have this:
Dim homeImage As String = GetLocalResourceObject("HomeImage")
imgBtnHome.Attributes.Add("OnMouseOver", HomeImage)
and in the resx file, i've tried these, but they don't work: (note the single and double quotes)
key: HomeImage value: "this.src='images/HomeImage.gif'"
key: HomeImage value: "this.src='images/HomeImage.gif'"
is it even possible to read "quoted" text from a local resource file?
in my application i have to read from an excel files and check the value of every cell i'm using an OleDb connection to open it and reading but i have this issue if some of the cells in the excel sheet is having this warning when i try to read it returns DBNull ??could any one give me a clue ....knowing that i can not force the user for not having this warning ...i have to solve this within my code .
View 5 RepliesI m reading a text file. After reading all the lines, I want to insert those records into respective fields in database.
So how to store the 1 or 2 or 3 or 4 or 5 lines of records until I read the last record.?
[code]....
first 9 number is emp id, next is name and next is salary.
While I m reading, I can store only last record. How to store all the records in a array to store in the database after reading all the lines.
I have a csv file with 5 columns. I need to read this file using c# and have to write the contents to the table in database which has 5 columns to it.
if anyone know the code or steps to do this.
I urgently need to find a way of reading data from a .CSV or .xls(Excel) file into an sql database so that I can use it in my asp.net 2.0 application.
View 4 RepliesI have the following data that basically I only need a few bits of information from:
Resource:X - Y;Z - Å;Type:(all) From Date:
07/12/2010 - To Date 07/12/2010 Sort
by:Time Include Referring
source/physician:No Footer:Default
Criteria:None
","Appointments","X,
Y","ZAssociates","Monday, July 12,
2010","Time","Patient Name","Patient
ID","Appt. Type","Ref. Source/
Physician","Phone","Type","DOB
","Z, X","Y","7/12/2010
12:00:00AM","Time","Patient
Name","Patient ID","Appt.
Type","Phone","Type","DOB "," 7:30
[snip]
The only things I need from this are:
Patients Name
Drs Name
Patients Phone Number
Appt Time
Appt Date
and the rest of the information I can discard. A customer uploads this as a .csv file (even though it really isn't as you can see) and I'd like to parse the needed information and post that to my SQL database and discard the rest. I think I can do this with a dataset but I've never built that before. The fields from the customer will always be the same and the fields I will need will always be the same. Also, the date time has to be in the format of yyyy/mm/dd:hhmm and the phone number always has to have 512 as a prefix. Here is the code I currently have for my site:
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
Protected Sub Submit1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim SaveLocation = "\xxxWEB3wwwrootWebfile1RemindersDoug_Ancildoug.csv"
If UploadFile(SaveLocation) Then
'the file was uploaded: now try saving it to the database
SaveToDatabase(SaveLocation)
End If
End Sub
Private Function UploadFile(ByVal SavePath As String) As Boolean
Dim fileWasUploaded As Boolean = False 'indicates whether or not the file was uploaded
'Checking if the file upload control contains a file
If Not File1.PostedFile Is Nothing And File1.PostedFile.ContentLength > 0 Then
Try
'checking if it was .txt file BEFORE UPLOADING IT!
'You used to upload it first...but the file could be a virus
If File1.FileName = ("doug.csv") = False Then
'The file is not the expected type...do not upload it
'just post the validation message
message.Text = "Sorry, thats not the correct file."
message2.Text = "Please locate and upload 'doug.csv'"
Else
'The file is a .txt file
'checking to see if the file exists already
'If it does exist Deleting the existing one so that the new one can be created
If IO.File.Exists(SavePath) Then
IO.File.Delete(SavePath)
End If
'Now upload the file (save it to your server)
File1.PostedFile.SaveAs(SavePath)
'After saving it check to see if it exists
If File.Exists(SavePath) Then
'Upload was sucessful
message.Text = "Thank you for your submission."
fileWasUploaded = True
Else
'the file was not saved
message.Text = "Unable to save the file."
End If
End If
Catch Exc As Exception
'We encountered a problem
message.Text = "Your file was not in the correct format. Please contact Customer Service at xxxx-xxxx-xxxx."
End Try
Else
'No file was selected for uploading
message.Text = "Please select a file to upload."
End If
Return fileWasUploaded
End Function
Private Sub SaveToDatabase(ByVal SavePath As String)
Try
Dim sqlQueryText As String = _
"BULK INSERT dialerresults " + _
"FROM '" & SavePath & "' " + _
"WITH ( FIELDTERMINATOR = ',' , ROWTERMINATOR = '
' )"
' and bulk import the data:
'If ConfigurationManager.ConnectionStrings("Dialerresults") IsNot Nothing Then
'Dim connection As String = ConfigurationManager.ConnectionStrings("Dialerresults").ConnectionString
Dim connection As String = "data source=10.2.1.40;initial catalog=IVRDialer;uid=xxxx;password=xxxxx;"
Using con As New SqlConnection(connection)
con.Open()
' execute the bulk import
Using cmd As New SqlCommand(sqlQueryText, con)
cmd.ExecuteNonQuery()
End Using
End Using
'Else
'message.Text="ConfigurationManager.ConnectionStrings('Dialerresults') is Nothing!"
'End If
Catch ex As Exception
message.Text = "Your file was not in the correct format. Please contact Customer Service at xxxxxxx."
End Try
End Sub
End Class
I have a text file (test.txt) which contains n number of data like:
1234778
4567444
8970451
1212455
testhsdd
weresdfy
.
.
.
etc
I need to fetch first 75 data or lines and insert in the sql table. Again next 75 data or lines and insert in the sql table. Again next 75 data or lines and insert in the sql table until it finish all.How i can do it in ASP.NET with C#
I know this is probably a pretty easy thing to do and it is if I can upload the file and store it onto the hard drive of the server. What I need to do is read the text file into memory and then parse through it one line at a time. Anyone have any code that demonstrates that?
View 8 Replieshow to read the data's in the text file using sql server 2000 and 2008. i have a text file in a server and it contains one column name with the multiple column values i need to read that informations and i need to update in a table in the database.
View 2 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 hava text file
<select name="Dr_Person" id="Dr_Person" class="required"><option value="1013">1013 PRAVEEN</option><option value="1043">1043 NKULSHRESTH</option><option value="1101">1101 N.K.KULSHRESTHA</option><option value="1002">1002 RAJIV</option>
<option value="1110">1110 SK SHARMA</option><option value="1050">1050 PIYUSH</option><option value="1044">1044 ARUN</option></select >
I am currently working on a project where I am trying pull a list of entries from an Oracle database depending on a selection that is made by the user via a Drop Down list. Then I want provide a user with a list of options that they can select that is related to the drop down option that they have selected. For Example:
First Drop Down from database: Honda, BMW, Ford
If user selects:
Honda -- options that are available in the separte table in the database for this entry are -- Type, Engine Size, Colour
BMW -- options that are available in the separte table in the database for this entry are -- Colour, Wheel Trims, Extra's
Ford -- options that are available in the separte table in the database for this entry are -- Extra's
What I wanted to do is have a form displayed to the user where thy can say select a car eg. "BMW" and then on the change of that drop downs index the site will do a call back and retrieve the entries for the BMW options in the seperate tabel, these being Colour, Wheel Trims, Extra's. Then it will put these details in a DataSet and then i wanted to create a new text box or input field for the users to enter details in. I have tried the below code with no success as I get an error on my for loop of looking through the options DataSet.
[Code]....
how to create a tree view using a text file i have a textfile..ab.txt...................
Personal
lmnk................................................
Qualification Educational[code]...
how to create a tree view with node
Personal;Qualification Educational;
Experience
I have to create a text box where if user will enter something it should show the values from database like google shows.e.g If i press a it should display a if i have entered AJ it should show all the list which start from AJ.Same like google.
View 10 RepliesI have this data url:
http://10.80.137.110/data
It returns something like this:
F|70.5|48.1|-999.9|-999.9|-999.9|-999.9|72.2|44.3|-999.9|73.4|38.1|-999.9I first want a way to read this line so i can write it with response.write. how would i also break those figures up by the"|" so the array would only store the numbers?