Thanks for responding. I have posted all my code here.
http://www.loritompkins.com/sqlnop/code.html There is something wrong with the way I am making this second connection. Maybe it needs to be converted to a string? I can't seem to figure it out. The only thing I changed where the lines in red. They were formerly select statements FROM THIS (second statement) Dim myCommand As SqlCommand = new SqlCommand("Select * From dbo.tbltopicDesc Where topicID='" & myDropDownList.SelectedItem.Value & "'",myConnection) To this Dim myCommand As SqlCommand = new SqlCommand("proc_clname", myConnection) Here it is working with all select statements http://www.loritompkins.com/sqlnop/pulldowngrid2.aspx Here it fails [no data paints to the grid from reader] http://www.loritompkins.com/sqlnop/pulldowngrid6.aspx --- In [email protected], Dean Fiala <[EMAIL PROTECTED]> wrote: > According to the code in your link, the DataReader is closed after the > reader is executed... > > myDataReader = myCommand.ExecuteReader(CommandBe havior.CloseConnection) > > Are you sure you are calling myConnection.Open() again > before calling this code... > > Dim myCommand As SqlCommand = new > SqlCommand("secondstoredprocedure", myConnection) [this fails] > > HTH > -- > Dean Fiala > Very Practical Software, Inc > http://www.vpsw.com ------------------------ Yahoo! Groups Sponsor --------------------~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
