How datareader error

Question

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() + ; 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?

Vulpes · 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 { if (!reader.IsDBNull(0)) { ReadCouncilorsVotes[count] = reader[0].ToString() + ; } count++; } vote.Close();

Rahul M · Answer

yeah. It works fine as Vulpes has mentioned. Try also to use Convert.ToString() function as it handles null value.

Pravin More · Answer

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.

Black Diamond · Answer

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...

Rahul M · Answer

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.