There is no row at position 0: Selecting value of dropdown list

[arial]

Hi ,

I have two two down list on my .net form.
I am running a query to return a result based on what is selected from drop down list .... but it is not working for me.

I get error message: There is no row at position 0.

I know I have a data in it my database. and i get the result when i put actual value in this query rather than selecing from drop down list.

Here is my query:

                Qcheckdata.SelectCommand.CommandText += " AND CRW1_NAME =  '"+ dpcrwlist1.SelectedItem+"%'";                                //Qcheckdata.SelectCommand.CommandText += " AND CRW2_NAME = '"+ dpcrwlist2.SelectedItem+"%'";
 

Please help me.

Thanks,

[vanc]

Hi ,

I have two two down list on my .net form.
I am running a query to return a result based on what is selected from drop down list .... but it is not working for me.

I get error message: There is no row at position 0.

I know I have a data in it my database. and i get the result when i put actual value in this query rather than selecing from drop down list.

Here is my query:

                Qcheckdata.SelectCommand.CommandText += " AND CRW1_NAME =  '"+ dpcrwlist1.SelectedItem+"%'";                                //Qcheckdata.SelectCommand.CommandText += " AND CRW2_NAME = '"+ dpcrwlist2.SelectedItem+"%'";
 

Please help me.

Thanks,

I think you need to provide more information about datareader, push in more code, I don't think your command text has any problems. Are they drop down list?

[arial]

yes,

there are drop down list.

Thank You,

[Shashi Sadasivan]

try debugging your code, and check the final query that is being built after selectng the values from the drop down lists.

and then paste that query string into your query editor in your DB interface and check the same.

cheers