i want to display the series as per upto date

See more:

C#

ASP.NET

I give the codes below plz solve

I want to change the query for ----below code

SqlDataAdapter da_series = new SqlDataAdapter("select top(1) group_title,Image_Name,group_id,group_video_no,Video_id,Video_Name,V_description,convert(varchar, date, 103) as To_Date,left(convert(varchar, date, 103), 2) as up_date, left(convert(varchar, date, 107), 3) as month from UploadVideo where group_title ='" + group_title.Trim() + "' order by group_video_no desc", con);

-----------------------------------------
-----------------------------------------

private void LoadData()
    {

        SqlDataAdapter da = new SqlDataAdapter(" select top(3) group_title,Video_id,Video_name,group_id,Image_Name, Speaker, left(convert(varchar, date, 103), 2) as up_date, left(convert(varchar, date, 107), 3) as month, V_description from UploadVideo where Image_Name<>'' order by Date desc", con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        DataList1.DataSource = ds.Tables[0];
        DataList1.DataBind();

        DataSet ds_series = new DataSet();
        DataSet ds1 = new DataSet();
        DataSet ds2 = new DataSet();

        SqlDataAdapter da1 = new SqlDataAdapter("select count(distinct(group_id)) from UploadVideo where group_id<>''", con);
        da1.Fill(ds1);




        int group_no = Int32.Parse(ds1.Tables[0].Rows[0][0].ToString());

        SqlDataAdapter da2 = new SqlDataAdapter("select distinct(group_title) from UploadVideo where group_id<>''", con);
        da2.Fill(ds2);
        for (int i = 0; i < group_no; i++)
        {
            string group_title = ds2.Tables[0].Rows[i]["group_title"].ToString();

            SqlDataAdapter da_series = new SqlDataAdapter("select top(1) group_title,Image_Name,group_id,group_video_no,Video_id,Video_Name,V_description,convert(varchar, date, 103) as To_Date,left(convert(varchar, date, 103), 2) as up_date, left(convert(varchar, date, 107), 3) as month from UploadVideo where group_title ='" + group_title.Trim() + "' order by group_video_no desc", con);
            
            da_series.Fill(ds_series);

                DataList8.DataSource = ds_series.Tables[0];
                DataList8.DataBind();
                DataList8.Visible = true;



        }
    }