I am getting the following error when passing the select item in a drop down list box to a datagrid. I am using inline sql statement not a SP. I have checked the syntax and don't knwo what else to check. Any help would be appreciated.

Server Error in '/ConnectionInformation' Application.
--------------------------------------------------------------------------------

Could not find stored procedure 'False'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'False'.

Source Error:


Line 48:
Line 49: objConnection.Open()
Line 50: dgConnectionInformation.DataSource = objCommand.ExecuteReader
Line 51: dgConnectionInformation.DataBind()
Line 52: objConnection.Close()


Source File: \\My Documents\Visual Studio Projects\ConnectionInformation\ConnectionInformati on\default.aspx.vb Line: 50

Stack Trace:


[SqlException: Could not find stored procedure 'False'.]
   System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
   System.Data.SqlClient.SqlCommand.ExecuteReader() +42
   ConnectionInformation.WebForm1.subListChange(Objec t S, EventArgs E) in \\My Documents\Visual Studio Projects\ConnectionInformation\ConnectionInformati on\default.aspx.vb:50
   System.Web.UI.WebControls.ListControl.OnSelectedIn dexChanged(EventArgs e) +108
   System.Web.UI.WebControls.DropDownList.System.Web. UI.IPostBackDataHandler.RaisePostDataChangedEvent( ) +26
   System.Web.UI.Page.RaiseChangedEvents() +115
   System.Web.UI.Page.ProcessRequestMain() +1081

 Is the text 'False' in your SQL or in your data? is you data properly quoted? could you post your SQL Code too? thanks!

Regards,
Meredith Shaebanyan

if u r sure the SP name is correct! write owner name if u connect with another user.

Always:),
Hovik Melkomian.