How to skip last row ofOLEdbReader in C#?

Yes,Vulpes

This is the problem with the OleDbDataReader is that you don't know how many rows there are to be read until it's read the last one. 
Whislt i've found a workaround for this and would like to share with you all .
@ time of reading CSV used this code,yes it may be bit odd but satiesfied my requirement

string line = string.Empty;

            string tempFileName =Path.GetTempFileName(); //@"E:\DownLoadCSV.txt";

            StreamReader strReadr = new StreamReader(DownloadFileWithFullPath);

            StreamWriter strwriter = new StreamWriter(tempFileName);

            while ((line = strReadr.ReadLine()) != null)

            {

                if (!string.IsNullOrEmpty(line))

                {

                    line = line.Replace("\"\"", "\"");

                    strwriter.WriteLine(line);

                }

            }

            strReadr.Close();

            strwriter.Close();

            File.Copy(tempFileName, DownloadFileWithFullPath, true);

            File.Delete(tempFileName);

The problem with the OleDbDataReader is that you don't know how many rows there are to be read until it's read the last one.

So, unless you know in advance how many records are going to be returned, there's no way to skip reading the last row entirely.

hi sachin,

You may use the "as" operator combined with the "??" operator for default values. Value types will need to be read as nullable and given a default.

string test1 = sqlreader[index] as string; // for string value.
int myInt = sqlreader[index] as int? ?? default(int); // for int value.

hope this will help you.

Hi 

Thanks for your initiate.

I've already tried this.this function use to check the Column value existence.
I want to skip the complete row from any excel sheet or csv file.

Kind of we do have skip function in LINQ.

I'm using C# 3.0.

Thanks 

Chees DotNet :)

If you're trying to read the value of a particular column which has non-existent data, then you can use the IsDBNull method to check whether there's any data or not first.

For example, if it's the column with an index of 'n' that you're trying to read:

if (!reader.IsDBNull(n))
{
   // read the actual value
}

HI Folks

There is no update on this article since few days.
Can anyone have a look and advise me to come out from this issue.

Hihgly Thankful.