database details....................
SNO,NAME ,FATHERNAME,DATEOFBIRTH, MOBNUMBER,ADDRESS,QUALIFICATION
1 svr ant 15/05/1990 98876655 hyd btech
2 ajr fgh 16/05/1990 99877778 hyd btech
3 raju ggg 15/09/1998 98765678 ju btech
i wan output like this
svr ant 15/05/1990 hyd btech send sms to cusmobile(98876655)
ajr fgh 16/05/1990 hyd btech send sms to cus mobile(99877778)
...................
WHEN I SELECT ROW NAME, FATHERNAME ,DATEOFBIRTH, ADDRESS THIS FOUR FIELDS ARE SEND TO SMS TO CUSTMER MOBILE
.....
i have quarie but how to write in gridview
select NAME +' '+FATHERNAME + ' ' + ADDRESS + ' ' + MOBNUMBER + ' ' + DATEOFBIRTH as DETAILS FROM CUS