Hi,<BR><BR>I want a DropDownList in a DataGrid to display values from two database columns, "ItemID" and "ItemTitle", separated by a dash. The Access table these columns are from, "tblItems", is already being held in a DataTable (also called "tblItems"), but I couldn&#039;t figure out the syntax for pulling these two columns out of the existing DataTable, connecting them with a dash, and then binding the result to the DropDownList.<BR><BR>I eventually did achieve the desired result by the wasteful method of creating a SECOND DataTable ("tblItemParents") via the following SQL: <BR><BR>"SELECT tblItems.ItemID & &#039; - &#039; & tblItems.ItemTitle AS ItemParent FROM tblItems ORDER BY ItemID;"<BR><BR>and then binding this second DataTable to the DropDownList. But can this solution can&#039;t be optimal, as I have created a second DataAdapter, a second database query and a second DataTable just for this one DropDownList, when all the information exists already in my first DataTable - if I just knew how to get it out in the right format.<BR><BR>Can anyone tell me how I can do this without having to create a second query and DataTable?<BR><BR>Thanks,<BR><BR>JON<BR><BR><BR><B R><BR><BR>**************************************** **************<BR>THE CODE (HIGHLIGHTS)<BR>********************************** ********************<BR><BR><BR><BR><BR><BR><BR>Su b Page_Load(sender as object, e as eventargs)<BR> Dim objAdapter as New OleDbDataAdapter ( "SELECT * from tblItems", objConn )<BR> objConn.Open()<BR> objAdapter.Fill(ds, "tblItems")<BR> dg.DataSource = ds<BR> dg.DataMember = "tblItems"<BR><BR><BR> Dim objAdapter2 as New OleDbDataAdapter ( "SELECT tblItems.ItemID & &#039; - &#039; & tblItems.ItemTitle AS ItemParent FROM tblItems ORDER BY ItemID;", objConn )<BR> objAdapter2.Fill(ds, "tblItemParents")<BR><BR>end sub<BR><BR><BR>Sub myDataGrid_ItemDataBound(sender As Object, e As DataGridItemEventArgs)<BR> If (e.Item.ItemType = ListItemType.EditItem) then<BR> Dim ddItemParent as DropDownList = e.Item.FindControl("ddItemParent")<BR> ddItemParent.DataSource = ds.Tables("tblItemParents").DefaultView<BR> ddItemParent.DataTextField = "ItemParent"<BR> ddItemParent.DataBind()<BR> end if<BR>end sub<BR><BR><BR><BR><BR>&#060;asp:DataGrid id="dg" runat="server"<BR>AutoGenerateColumns="False"<BR>O nEditCommand="dg_edit"<BR>OnCancelCommand="dg_canc el"<BR>OnUpdateCommand="dg_update"<BR>OnItemDataBo und="myDataGrid_ItemDataBound"<BR>&#062;<BR><BR><B R>&#060;Columns&#062;<BR> &#060;asp:TemplateColumn&#062;<BR> &#060;EditItemTemplate&#062;<BR> &#060;b&#062;ItemParent: &#060;/b&#062;&#060;asp:DropDownList id="ddItemParent" runat="server" /&#062;<BR> &#060;/EditItemTemplate&#062;<BR> &#060;/asp:TemplateColumn&#062;<BR><BR>&#060;/Columns&#062;<BR><BR><BR><BR>