ASP.NET

  private void BindData()<br />
    {<br />
<br />
        try<br />
        {<br />
            SqlConnection myConnection = new SqlConnection(ConnectionString);<br />
            SqlCommand myCommand = new SqlCommand("SP_S1", myConnection);<br />
            myCommand.Parameters.Add("@ch1", SqlDbType.VarChar, 30).Value<br />
     = DropDownList1.SelectedItem;<br />
<br />
            myCommand.CommandType = CommandType.StoredProcedure;<br />
            SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand);<br />
            DataSet ds = new DataSet();<br />
<br />
            myAdapter.Fill(ds, "Table1");<br />
            myConnection.Open();<br />
            myCommand.ExecuteNonQuery();<br />
            GridView1.DataSource = ds;<br />
<br />
            GridView1.DataBind();<br />
            myConnection.Close();<br />
        }<br />
        catch (Exception)<br />
        { }<br />
<br />
<br />
    }<br />