Calling a procedure

J

Jon Cosby

How do you call an existing procedure? My database has a procedure called
"StudentSchedule" with one parameter, @StudentID. I'm trying to fill the
results in a datagrid with a StoredProcedure command. The grid is not even
showing on the page.

SqlCommand cmdSchedule = new SqlCommand("StudentSchedule", this.cnBCC);
cmdSchedule.CommandType = CommandType.StoredProcedure;

SqlParameter studID = cmdSchedule.Parameters.Add("@StudentID",
SqlDbType.NChar, 9);
studID.Value = this.tbSID.Text.Trim();

SqlDataAdapter daSchedule = new SqlDataAdapter(cmdSchedule);
DataSet ds = new DataSet();

daSchedule.Fill(ds);
this.dgStudents.DataSource = ds;


Jon Cosby
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top