Basics With Stored Procedures.....please

Hi there, I'm still fairly new to asp.net / c#





I've setup my stored procedure, but now what?


I want to display the information (only one record it will return) on the page / NOT using a datagrid or list, just simple.....I guess using an asp:label?????


Could someone tell me what I need to do!!!





Also, are there any proper resources out there that just show you right out of the box howto insert / update / delete with sp's?, show / view, just proper simple source code?





THANKS!





my code:


// Creating the database connection


SqlConnection objConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_conn_main"]);





// Creating the stored procedure 4 the webpage


// Instantiate a Sql Command


SqlCommand webpage_view = new SqlCommand("stpr_webpage_view", objConn);


// Declare that the T-SQL statement that will be executed is a stored procedure


// Use a CommandType.Text to execute a T-SQL Query


webpage_view.CommandType = CommandType.StoredProcedure;


SqlParameter webpage_id_parm = webpage_view.Parameters.Add("@webpage_id", SqlDbType.Int);


webpage_id_parm.Value = "1";


// Create a SqlDataAdapter to manage the connection and retrieve the data


SqlDataAdapter da_1 = new SqlDataAdapter();


// Instantiate a Dataset that will hold the data retrieved from the database using the select command


DataSet ds_webpage = new DataSet();


da_1.SelectCommand = webpage_view;


// Retrieve the data into the dataset using the SqlDataAdapter.Fill command


da_1.Fill( ds_webpage, "webpage_title" );


DataView dv2 = ds_webpage.Tables[0].DefaultView;


if ( !this.IsPostBack ) {


this.DataBind ( );


}