i have to show all the rows in my query where in here am i making mistakes. :     --

    public Section SectionView(object id, SqlConnection conn)
            {
                using (SqlCommand cmd = new SqlCommand())
                {
                    if (conn.State == ConnectionState.Closed) conn.Open();
                    SqlDataAdapter sqlda = new SqlDataAdapter("TMR_SECTION_VIEW", conn);
                    SqlDataAdapter da = new SqlDataAdapter("data", conn);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.CommandText = "TMR_SECTION_VIEW";
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@sectionID", id.ToString);
                    cmd.Parameters.AddWithValue("@name", name);
                    
                    da.SelectCommand = cmd;
                    DataTable dt = new DataTable();
                    DataTable dtbl = new DataTable();
                    sqlda.Fill(dtbl);
                    cmd.ExecuteNonQuery();
                    return id;
                }
    
            }



my store procedures query is

ALTER PROCEDURE [dbo].[TMR_SECTION_VIEW]
	@sectionID int, @name varchar(100)
AS
BEGIN
	
	
	SELECT * FROM Section Where sectionid = @sectionID 
END


