Dean-- I think that's a BINGO! thanks so much. Now on to the next perplexing adventure....
- -- In [email protected], Dean Fiala <[EMAIL PROTECTED]> wrote: > You need to read the values from the controls on the page and pass > them as parameters to the stored procedure. The stored procedure > cannot read the controls on the page. > > Stored Procedure should look something like... > > CREATE PROCEDURE dbo.proc_selDesc2 > @Classname nvarchar(50) > AS > Select * From dbo.ClassDescription d, dbo.Classes c > Where d.classid=c.classid > and c.clname= @ClassName > > GO > > Your code should look something like > Dim myCommand As New SqlCommand("proc_selDesc2", myConnection) > myCommand.CommandType = CommandType.StoredProcedure > > Dim myParm As SqlParameter = myCommand.Parameters.Add("@ClassName", > SqlDbType.NVarChar, 50) > myParm.Value = ddl1.SelectedItem.Value > > Then you call your execute reader. > > Here's a full example... > http://msdn.microsoft.com/library/default.asp?url=/library/en- us/cpguide/html/cpconusingstoredprocedureswithcommand.asp > > > 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/
