asp.net - use multiple select queries to fetch data for grid view -
in .net 2008
i want bind data grid view using multiple select queries reason want data come multiple data , have to processing on data before displaying in grid view
an example (i dont have this)
i have 2 tables 1 columns uid , uname named udata other columns uid , unum named uinfo problem want have uid uname , unum concatenated complex operation , display in grid view complex operation can done in c# , not in t-sql
i making case 1 single query cannot fetch data
so how do grid view
if gridview can display it, cannot make case "one single query cannot fetch data". union various select statements, making sure datatypes of columns align. have access concatenation operator on server, , various substring functions.
Comments
Post a Comment