NullReferenceException

Question

Hello I need your help how to handle this exception. The code run but after the while loop I have a NullReference Exception when trying to display the data. Code attached Thanks

Vivek Kumar · Answer

@Eric When you are using inline query then no need to use of below line. st.Parameters.AddWithValue(@SampleID value); you can simple achieve the result by changing the query like below. .... WHERE SampleID= + SampleList con))

Eric Mbiada · Answer

@Vivek Thanks for your reply I did that and I can get the right data displaying in SQL server by passing the sampleID value

Vivek Kumar · Answer

@Eric First Excute your query in sql server and check whether you are getting any data or not?

Eric Mbiada · Answer

@ Karthi I just debugged my code I don't understand why st.ExecuteReader() is null when st.Parameters.AddWithValue(@SampleID value) is equal to the value of SampleList Any suggestion Please Eric

Karthi Keyan · Answer

@Eric Check Null value is passing or not. This Exception occures because of empty value passing to variable.