core java-concat string tokenizer

Question

1.00/5 (1 vote)

See more:

hello sir.........i am doing one jsp project and i am having one table with columns first name
middle name
last name
mobile number
address
i want to concat first,middle,last name and i have to show a datagrid view as Name Mobile Number Address

for example-if table contais data as-
first name-raju
middle name-kumar
last name-dinkar
mobile no-89343849
address-bangalore

then i have to show data grid as-
Name-raju kumar dinkar
mobile no-89343849
address-bangalore

how can i do...i am trying using concat string tokenizer but its not happening.........plz haelp me..its urgent..????????

Posted 18-Jun-12 3:42am

kumar ankit1

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2012-06-18T04:03:00

Solution 1

Why not append/concatenate the column values in query itself when fetching the data?

For example:

SQL

SELECT
  (Firstname +" "+ middlename +" "+ lastname) as Name,
  mobilenumber
FROM
   myTable

Posted 18-Jun-12 4:03am

Sandeep Mewara

v2

Comments

kumar ankit1 19-Jun-12 14:15pm

sir i am using one query as-
String query ="SELECT(first_name +" "+ middle_name +" "+ last_name) as Name,city,state FROM user";
but here its showing one error as ';' expected.....my query is correct but why its showing error....??????

Sandeep Mewara 22-Jun-12 1:06am

Difficult to comment.

Query reference link: http://msdn.microsoft.com/en-us/library/ms177561.aspx

core java-concat string tokenizer

1 solution

Solution 1

Add your solution here

Preview 0

core java-concat string tokenizer

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us