Dim dadptclaim As New SqlDataAdapter("SELECT prsid, fname + ' ' + name as na FROM person join claimant on prsID=prsCLMID WHERE (prsID =prsCLMID)", sql) dadptclaim.Fill(ds, "CLM") claimant.DataSource = ds.Tables("CLM") claimant.DataValueField = "prsid" claimant.DataTextField = "na" claimant.DataBind()
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)