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;
}
}