SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();

                slqCmd = new SqlCommand("procedure1", sqlConn);
                slqCmd.CommandType = CommandType.StoredProcedure;
                slqCmd.Parameters.AddWithValue("id", Request.Params["id"]);

                sqlDataAdapter.SelectCommand = sqlCmd;

                DataSet dataset = new DataSet();
                sqlDataAdapter.Fill(dataset);