C#

sankar i wrote:

any way where we can read excel file in blocks("x" rows at a time)

static void Main(string[] args)
        {
            string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;;Data Source=C:\temp\XlsJetTest.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";";
            OleDbConnection conn = new OleDbConnection(connStr);
            OleDbCommand comm = new OleDbCommand("select top 10 * from [Sheet1$]", conn);
            conn.Open();

            OleDbDataAdapter da = new OleDbDataAdapter(comm.CommandText, conn);
            DataTable dt = new DataTable();
            da.Fill(dt);

            Console.WriteLine("RowCount:\t{0}", dt.Rows.Count);
            Console.ReadLine();
        }

Sharma Dinesh Kumar wrote:

dvs.RowFilter =Name like '%Book%'

dvs.RowFilter = Name Like '%Book%' AND Name like '%this is%'

himanshu2561 wrote:

What have you tried so far???