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 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 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]....
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#,
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 RepliesIm 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 Repliesi have a table.xml file how can i read it perticular field in asp.net?
i want read only name field in hole xml file an d store it in database
file formate is:-
[code]....
I've been searching for some way to open a pdf file on a web browser control and then read the content as text to search for a particular string. So far, I found out that I can display the pdf file on the browser quite easily but I have not been able to read the content from code.
View 5 RepliesI just purchased a premium Windows hosting account from 1&1. I wish to host my site on there. I have been working on it for quite some time.
The most important part of my website is Authentication, and I cannot get my database to work.
I need to get my site to be able to connect to E:BlahBlahBlahApp_DataASPNETDB.mdf. It is SQL Server 2005. And yes, my hosting package supports it. I have a database set up. Would I need to configure my database to read the .mdf? Or is there a special connection string for files.
am trying to read the metadata of a video file and also change/add some fields to that.
Note: .Net 3.5, VB
how can i read a doc file and show it on webpage like if someone upload his/her resume one can see upload resume in asp.net page like monster.com and other job portal side do.
View 2 RepliesHow can i read CSV file without using Oledb connection.
View 1 RepliesI am having a text file in application path ~/Upload/txtName.txt.I am having some content inside the txtName.txt. I need to show the content inside the txtName.txt. to the Text box dynamically.
View 1 RepliesI am having a following .cs file with some classes as follows
public partial class Student {
public int ID { get; set;}
}
public partial class Student2 {
public string name { get ; set; }
}
I am having above code in my .cs file.
When i upload that .cs file, i need to get the class name that i am having in the .cs file.
(i.e) Student,Student2.
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?
How to set the path to read the file which is in remote machine and display it in TEXTBOX in web browser.
View 2 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();
}
