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]....
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 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 have tab delimited .xls file. I want read this to a dataset. Oledb connection string is given below. But i'm getting one error on objConn.Open();
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0";
OleDbConnection objConn = new OleDbConnection(strConn);
objConn.Open();
Error : External table is not in the expected format.
How can i read tab delimited .xls file to a dataset using oledb connection?
I have some code that reads records from an excel file and then imports that data into an sql database. The issue only happens when the excel file has more then 350 rows in it. In the middle of the import it just stops executing and I get directed to the 'Internet Explorer cannot display the webpage' page or just a blank page when using firefox.
I dont get any time out errors or any error at all but still I tried messing around with the script timeout settings but still does the same thing at about the 2 min 30 sec mark.
[Code]....
I need to be able to read an excel file from a file upload control but I can not save the file to disk first, it must be done in memory.
[Code]....
Above is my code for reading the data file if it IS saved to disk, but again, I have to be able to do this without saving the file to disk, it must be done in memory. I have not been able to find any sample code anywhere on how to do this from memory, everything seems to force the file be uploaded, saved to disk, and then read in the connection string, which again I can not do.
I understand how to use a connection string object to read excel sheets. What I don't know is how to follow a hyperlink inside excel, grab matching data from the linked page and return it to my database. Essentially, the spreadsheet has two columns:
Title | Class#
Class# has the hyperlink which links to an internal web site. The connected page has a course description and any pre-required classes that must be taken before you can take this class. This is where I'm rather stumped as I've not had to do this type of thing before.
1) I need to make reading CSV file from the fileupload and then retrieve the data.
2) I need to load CSV and the 3 columns rise two functions.
Load CSV data and then stored in a database, but I need to save storage space vary according to 3 column.
CSV Example:
1 column - Cat, 2 column - Black, 3 column - 1
1 column - Dog, 2 column - Brown, 3 column - 2
1 column - Cat, 2 column - Black, 3 column - 1
1 column - Dog, 2 column - Brown, 3 column - 2
Now I need to load the CSV in C # and column 3 to distinguish what the operation is carried out.When the load line in column 3 contain the value 1, so will save the table 'Cats' when the value 2 and is saved in the table "Dogs".(Note: Data are separated ";")
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.
I'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 have a table with just a column and a row in a table that it save just a file with size 1.5 GB ! C# application and sql server are in different machines. I want to read that file by DataReader every 100 MB then save all 100 MB files to disk by "FileMode.Append" for file stream and collect them to one file.
View 1 RepliesI'm Using a DataReader to Read about 100,000 records, my code look like :
[Code]....
I have a per row computation in reading the rows on GetMyType2Info() method, and this method also another method that I return only one record by ExecuteReader(). the problem is that when the MyTypeList (List<T>) has about 21,000 Items of MyType (<T>) System.OutOfMemoryException is thrown. wanted to know how to resolve this and wanted to know more about the maximum size of List<T> capacity. in addition the execution of the main Query with 100,000 records take about 4 seconds in SQLServer a record has only types of nvarchar , float,datetime and int
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 RepliesHow 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'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?
website 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 want to upload a text file and stored to my database. the column on my database it is longblob type.
View 6 RepliesI am working on a C# web application under visual studio 2005.
I want to import data from text file or excel file into a SQL 2005 database.
I have 3 columns in the text file separated by |, example of the text file format:
1|11122222|Name1
2|22299809|Name2
how to import data from text or excel file?
I am reading a word file and saving the contents into the database and retrieving it. One issue is that if word document contains a bold text or underlined text it is not getting saved into the same format. Is there any possible way to save and retrieve the rich text.
View 1 RepliesI 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 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 have a scenario where I have to read an excel file to dump records in a mysql database. The code generates an exception Sheet1 not found. I have pasted the code below. Please let me know the solution to the exception. I have given the correct read/write/modify settings to my excel file.
if (fileUpload1.PostedFile.FileName.EndsWith(".xls") || fileUpload1.PostedFile.FileName.EndsWith(".XLS"))
{
string fileName = Server.MapPath(fileUpload1.PostedFile.FileName);
string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=Excel 8.0";
// Create the connection object
OleDbConnection oledbConn = new OleDbConnection(connString);
try
{
// Open connection
oledbConn.Open();
// Create OleDbCommand object and select data from worksheet Sheet1
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]" , oledbConn);
// Create new OleDbDataAdapter
OleDbDataAdapter oleda = new OleDbDataAdapter();
oleda.SelectCommand = cmd;
// Create a DataSet which will hold the data extracted from the worksheet.
DataSet ds = new DataSet();
// Fill the DataSet from the data extracted from the worksheet.
oleda.Fill(ds, "RestaurantExcelData");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Response.Write("Data: " + ds.Tables[0].Rows[i].ItemArray[0].ToString() + "");
}
}
catch(Exception e1)
{
}
finally
{
// Close connection
oledbConn.Close();
}
}
else
{
Response.Write("File Not Excel (xls||XLS)");
}
Using C# to develop an application.I need to upload data ( which is in excel) to a sql table.
[Code]....
