Hi all, Im using the following codes to retrieve records from excel file.
OleDbConnection conn = new OleDbConnection (@"Provider=Mic rosoft.Jet.OLED B.4.0; Data Source=" + Path + "; Extended Properties='Exc el 8.0;HDR=Yes;IME X=1'");
OleDbCommand cmd = new OleDbCommand("S ELECT TOP 10 * FROM [Sheet1$] WHERE [Project] <> ''", conn);
DataSet ds = new DataSet();
da = new...
2 results in 0.0014 seconds.
-
Problem Retrieving From Excel in C#
-
OleDbDataAdapter question
I want to copy some record from a Access database to another Access DB. My
code as follow but not working. The destAdapter.Upd ate() return 0 record
affected.
Tell me what's wrong in my code?
public void CopyDataSet(int start, int end)
{
OleDbDataAdapte r sourceAdapter = new OleDbDataAdapte r("SELECT * FROM [nguoi
su dung dat] " +
"WHERE ID > " + (start - 1).ToString() +...
