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("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

[James J. Foster]

Add this line at the end:

this.dgStudents.DataBind();

--
James J. Foster, DotNetCoders
[url]http://www.dotnetcoders.com[/url]


"Jon Cosby" <jcosby@mindspring.com> wrote in message
news:bh8f1d$kf$1@slb2.atl.mindspring.net...

> 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
>
>