private void FillGrid() { try { StrSql = new StringBuilder(); StrSql.Length = 0; StrSql.AppendLine("Select Id,ClientName,FirmName,EMailId,MobNo"); StrSql.AppendLine("From Client_Mast"); StrSql.AppendLine("Order By ClientName"); dtTemp = new DataTable(); dtTemp = SqlFunc.ExecuteDataTable(StrSql.ToString()); GridClient.DataSource = dtTemp; GridClient.DataBind(); } catch (Exception ex) { Response.Write(ex.ToString()); } }