<div>
You can do it in the query:<br />
<a href="http://datawebcontrols.com/faqs/CustomizingAppearance/CombiningTwoFieldsIntoOneColumn.shtml" rel="ugc">http://datawebcontrols.com/faqs/CustomizingAppearance/CombiningTwoFieldsIntoOneColumn.shtml</a>
</div>


You can do it in the query:
http://datawebcontrols.com/faqs/CustomizingAppearance/CombiningTwoFieldsIntoOneColumn.shtml [http://datawebcontrols.com/faqs/CustomizingAppearance/CombiningTwoFieldsIntoOneColumn.shtml]

<div>
I tried this doesnt seem to work.... im getting a &quot;0&quot; in the field
</div>


I tried this doesnt seem to work.... im getting a "0" in the field

<div>
 &nbsp; &nbsp; &nbsp; &nbsp;Dim SqlString As String = &quot;SELECT a.accountNumber, SU.fname + ' ' + SU.lname AS repName, p.nom, p.prenom, p.telHome, d.dealerName, ST.statusName AS accountStatus FROM accounts AS a INNER JOIN profiles AS p ON a.accountNumber=p.accountN<wbr />umber INNER JOIN dealers AS d ON a.dealerId=d.dealerId INNER JOIN sysusers AS SU ON d.repId=SU.sysUserId LEFT JOIN accountStatus AS ST ON a.accountStatus=ST.statusI<wbr />d WHERE p.profile_type=1 and (a.accountStatus != 1 AND a.accountStatus != 8) AND a.deleted='false' ORDER BY ST.priority&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim da As MySql.Data.MySqlClient.MyS<wbr />qlDataAdap<wbr />ter = New MySql.Data.MySqlClient.MyS<wbr />qlDataAdap<wbr />ter(SqlStr<wbr />ing, conn)
</div>


       Dim SqlString As String = "SELECT a.accountNumber, SU.fname + ' ' + SU.lname AS repName, p.nom, p.prenom, p.telHome, d.dealerName, ST.statusName AS accountStatus FROM accounts AS a INNER JOIN profiles AS p ON a.accountNumber=p.accountNumber INNER JOIN dealers AS d ON a.dealerId=d.dealerId INNER JOIN sysusers AS SU ON d.repId=SU.sysUserId LEFT JOIN accountStatus AS ST ON a.accountStatus=ST.statusId WHERE p.profile_type=1 and (a.accountStatus != 1 AND a.accountStatus != 8) AND a.deleted='false' ORDER BY ST.priority"
        Dim da As MySql.Data.MySqlClient.MySqlDataAdapter = New MySql.Data.MySqlClient.MySqlDataAdapter(SqlString, conn)

<div>
<div class="content wysiwyg-content">
I would like to append first name and last name that appear in 2 fields into 1 field in my datagrid<br />
<br />
please help !
</div>
</div>


I would like to append first name and last name that appear in 2 fields into 1 field in my datagrid

please help !

concatenate to db fields in to one datagrid column

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,