two data filelds in my sql: forename and surname i want to concate to Client_Name in sql
my code:
private void FillGrid()
{
string txt = Convert.ToString(Session["UserName"]);
GridView2.DataSource = c1.SelectDs("SELECT Case_Ref,Forename+''+Surname as client FROM tbl_FPD WHERE UserName='"+ txt+"'");
GridView2.DataBind();
}
...
Go to the complete details ...