Respected Sir/Madam,
I have sending messaged details in my sql data base.In my Grid view have the following columns,
Name Rollno MsgTemplateName No of messages Sented
Ameer 1 Pongal
Robina 2 Diwali
Ameer 1 Pongal
Robina 2 Diwali
Ameer 1 Diwali
Robina 2 Pongal
I want to look like the follwing,
Name Rollno MsgTemplateName No of messages Sented
Ameer 1 Pongal 2
Diwali 1
Robina 2 Diwali 2
Pongal 1
I am using this sql query "Select name,rollno,tempname,count(*) from stumsg group by
name,rollno,tempname" .but i cant get the correct answer.please help me to told how to bind the sql count funtion answer in my grid view.
Reply Me ....... Thanking You!!!!