
sir i am using one query as- String query ="SELECT(firstname +" "+ middlename +" "+ 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....??????

Your query is not correct. Actually, what do you want to retrieve from the database with your query.Please clarify this.

actually...i have one table with five columns fname,mname,l_name,mobile,address.. now i have to concat fname,mname,l_name as Name. and mobile,address column will be same now i have to show datagrid view as Name,Mobile,Address.
For Example- f_name=raj m_name=kumar l_name=singh mobile=89785675 address=bangalore
i have to show datagrid as Name-raj kumar singh Mobile-89785675 Address-bangalore... how can i do it....plz help me.....?????????

sir...can you give me some kind of hint for my above question.........its very very urgent....!!!!!!!!waiting for your response........