Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 30, 2012 06:17 PM by grundebar
Apr 30, 2012 06:04 PM|LINK
Hi, Using VS 2010, vb.net with SQL 2008.
When a Dropdownlist selectedindex changed event is fired, I have to take that selection and pass it to the SQLServer Stored proc. But i keep getting an error that "Could not find Stored proc" This is my code. Please guide me where I am going wrong.
dim arttypeid as integer=me.ddl1.selectedindex
comm.Connection = sqlConn
= 0 To
ds1.Tables(0).Rows.Count - 1
cslist = ds1.Tables(0).Rows(i).Item(0)
Apr 30, 2012 06:17 PM|LINK
You are executing your comm object as if it had a sql statement "Exec ListValues 5". If you wish to do it this way, then change your commandType to Text. Otherwise, you need to add a command parameter and set its value to arttypeid.