Comments by Member 8589824 (Top 15 by date)

no i don't want text of label. i want the field name which i have bound to it

this control is in master page. and i want to access it in class file.. not in aspx.cs. page

okay.. but how can i join tables in c#?? this ans is for linq

kindly help me for this one

thnk u... i m very close to solution.. but now i cam across with new problem.
i have quey like this..

select datepart(month,InvoiceMaster.InvoiceDate)as mnth ,sum(InvoiceMaster.value) from InvoiceMaster
group by datepart(month,InvoiceMaster.InvoiceDate),InvoiceMaster.InvoiceDate having InvoiceMaster.InvoiceDate between '2010-1-31' and '2010-12-31'

i want total amount values month wise...
when i am trying to execute this query it only sums up 1st month's values.. e.g. in my data it only sums up 9th month's values.. but then it doesn't sums up 10th,11th 12th month's value.. 9th month appears first so it sums up only 9th month's values..

this one 1 know but i am asking how can i differenciate months in query because in database only dates are stored and i n textbox user enters dates. e.g 1-4-2010 in one textbox and 31-8-2010 in other textbox. now i want to show column names april, may ,jun, july, august.. how can i do this??? or how can i apply query for differnet months??

or can you tell me how view can be build?? i even don't know how to make a view based on date??

yeah but every time dates will be changed so how can i write query which have different parameters every time??? can you elaborate your answer??