How datareader error

Black Diamond

Hi,

This is the code.

vote.Open();
string query = "SELECT FullNames from CouncilorsSubVotes order by FullNames";
SqlCommand all = new SqlCommand(query, vote);
SqlDataReader reader = all.ExecuteReader();
reader.Read();
string ReadCouncilorsVotes = reader[0].ToString() + "";
if (ReadCouncilorsVotes == null)
{ }
reader.Read();
string ReadCouncilorsVotes1 = reader[0].ToString() + ""; <---------------------null(It jump, it can't continue read the other reader, i want that if one of the string is null it proceed to the next.)
if (ReadCouncilorsVotes1 == null)
{ }
reader.Read();
string ReadCouncilorsVotes2 = reader[0].ToString() + "";
if (ReadCouncilorsVotes2 == null)
{ }
reader.Read();
string ReadCouncilorsVotes3 = reader[0].ToString() + "";
if (ReadCouncilorsVotes3 == null)
{ }
reader.Read();
string ReadCouncilorsVotes4 = reader[0].ToString() + "";
if (ReadCouncilorsVotes4 == null)
{ }
reader.Read();
string ReadCouncilorsVotes5 = reader[0].ToString() + "";
if (ReadCouncilorsVotes5 == null)
{ }
reader.Read();
string ReadCouncilorsVotes6 = reader[0].ToString() + "";
if (ReadCouncilorsVotes6 == null)
{ }
reader.Read();
vote.Close();

I want that if one of the reader become null it proceed to the next reader...how to fix this problem?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted answer
Try:

string[] ReadCouncillorsVotes = new string[7]; // all elements null by default
vote.Open();
string query = "SELECT FullNames from CouncilorsSubVotes order by FullNames";
SqlCommand all = new SqlCommand(query, vote);
SqlDataReader reader = all.ExecuteReader();
int count = 0;

while (count < 7 && reader.Read())
{
if (!reader.IsDBNull(0))
{
ReadCouncilorsVotes[count] = reader[0].ToString() + "";
}

count++;
}

vote.Close();
0
Rahul M15y ago
yeah. It works fine as Vulpes has mentioned. Try also to use Convert.ToString() function as it handles null value.
0
Black Diamond15y ago
hi,

I already used while loop, but the data of my counter effected in while, which it cannot count correctly unlike when i use this code it counts correctly....the problem of this one, if one of my reader has read empty or null it cannot continue read to the next row of my table.....and i want to ask if there is a solution for that, in which even if it reads null or empty it continue read to the next rows...
0
Rahul M15y ago
Yes Praveen is right. Apart from loop, you also don't have check if data reaches to end of file and that one of the cause can be throwing error when you are reading next line data. As praveen mentioned, loop itself will take care for this.
0
Pravin More15y ago
Hi, why are you not using while here like below if you are checking same thing .....

          while(reader.Read())
            {
               string ReadCouncilorsVotes  = reader[0].ToString() + "";

                if (ReadCouncilorsVotes == null)
                   {

                   }
            }
i mean how you want exactly...??
correct me if m wrong.....

Thanx,
Pravin.


0