Stored proc not returning values RSS

• • Reply
  

  snailpace

  Member

  31 Points

  285 Posts

  Stored proc not returning values

  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.

  thanks

  dim arttypeid as integer=me.ddl1.selectedindex
  Dim cslist As String
  Dim comm As New SqlCommand
  comm.Connection = sqlConn
  comm.CommandType =CommandType.StoredProcedure
  comm.CommandText ="ListValues "& arttypeid
  sqlConn.Open()
  comm.ExecuteNonQuery()
  adapter1 =New SqlDataAdapter(comm)
  adapter1.Fill(ds1)
  For i As Integer = 0 To ds1.Tables(0).Rows.Count - 1
  cslist = ds1.Tables(0).Rows(i).Item(0)
  Response.Write(cslist)
  Next
  adapter1.Dispose()
  Catch ex As Exception
  Response.Write(ex)
  End Try
  sqlConn.Close()
  sqlConn.Dispose()

  
  

• • Reply
  

  grundebar

  Contributor

  4515 Points

  726 Posts

  Re: Stored proc not returning values

  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.

  "What I hear, I forget; What I see, I remember; What I do, I understand." --Confucius
  
  Remeber to Mark as Answer if this post helped you.
  • Marked as answer by snailpace on May 01, 2012 12:11 PM