Dear All,
public void GetDetailForum()
{
SqlConnection con = new SqlConnection(strCS);
SqlDataAdapter da = new SqlDataAdapter("select Author,forumID,forumTitle,forumDesc,Images from tblForum where forumID='" + Request.QueryString["forumID"] + "'", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
public void GetResponses()
{
SqlConnection con = new SqlConnection(strCS);
SqlDataAdapter da = new SqlDataAdapter("select responseby,responseID,GradeLevel,Points,responsemsg,Dateofpost,Convert(CHAR(10),Dateofpost,101) as Jdate from tblForumResponse where forumID='" + Request.QueryString["forumID"] + "' order by Dateofpost desc", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView2.DataSource = ds;
GridView2.DataBind();
}
this two tables join result for latest response in the forums displayed in first page which join use help me
Advance Thanks to all
chandru