hi everyone,
i have my datagrid populated with my Dataset
like
DataGrid1.DataS ource=Dataset1;
this data set contains the value of count the total of email sent ,receive and deliver for a particular user id now i want to display user id with taht data but i dont have user name in my dataset because i can not write query like
select uname,count(sen d_email) from table where uname="ABCD";
because here i used aggregate function
...here i m selecting the user name from listbox so the query will saw the count of send ,receive and etc information for that user.now i want to display the user name in Datagrid that i selected from listbox so how can i add that valu or column to datgrid
Regards........ ...........
Ripen
i have my datagrid populated with my Dataset
like
DataGrid1.DataS ource=Dataset1;
this data set contains the value of count the total of email sent ,receive and deliver for a particular user id now i want to display user id with taht data but i dont have user name in my dataset because i can not write query like
select uname,count(sen d_email) from table where uname="ABCD";
because here i used aggregate function
...here i m selecting the user name from listbox so the query will saw the count of send ,receive and etc information for that user.now i want to display the user name in Datagrid that i selected from listbox so how can i add that valu or column to datgrid
Regards........ ...........
Ripen
Comment