Calling a procedure

[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(, 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

 

[Terry Burns]

Have you set the datasource of your grid to your dataset (ds ) ??

 

[Jon Cosby]

this.dgStudents.DataSource = ds;

dgStudents is the grid.

Jon

 

[James J. Foster]

Add this line at the end:

this.dgStudents.DataBind();