Comments by rohit24c (Top 26 by date)

Name Dep YearofJoin
====================
x d 2010
y d 2010

a g 2010
b g 2010
c g 2012
====================
from this i want (y d 2010) & ((b g 2010) & (c g 2012))

Mean to say after groupby(Dep) i will get 2 groups from that group i want 1 more group

I need to get the items for a List if it occurs 1 in the List
List= {1,1,2}

i need 2 from the list as it occurs once.

its syntactically wrong.

this code returns me
items[0] as tag: "ABC" & att:"BBB"
but i want only the value [0] ABC,BBB

hello i have used the same code but it giving exception.



The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Any suggestions plz

its throughing exception
"String was not recognized as a valid DateTime."

its like i have 2 buttons to genarate pdf and generate excel both can be done ??

I have a save()
{
// i am writing logic to save the pdf here...
}
Button_click()
{
save();
}
Now ot take time to save all pdfs in a path by that time i can allow the user to use other AREAS of my application.

Guys i have a rdlc in my winforms Application which i am binding to
report-viewer through code so i need the path which i have hard coded.
But i need to get the path of rdlc something like this ~\rport1.rdlc
How can i achieve that ??
Please help

its show "An error occurred during local report processing". at 3rd line in your code.
Basically its a rdlc which has subreport and i am having dataset in that rdlc

Thats fine when you're using reportViewer but how to save the rdlc files directly as .pdf.
Any suggestions plz

case type when 'P' then 'Police:'
when 'A' then 'Ambulance' else 'Others'
but then results in Police:100 Ambulance:101 Police:200 Ambulance:201 but i want it like Police:100 Ambulance:101 Emergency Police:200 Emergency Ambulance:201 here in the table i need to filter it based on slno also that i am not able to do.

case type when 'P' then 'Police:' when 'A' then 'Ambulance' else 'Others' but then results in Police:100 Ambulance:101 Police:200 Ambulance:201 but i want it like Police:100 Ambulance:101 Emergency Police:200 Emergency Ambulance:201 here in the table i need to filter it based on slno also that i am not able to do.

case type
when 'P' then 'Police:'
when 'A' then 'Ambulance'
else 'Others'
but then results in
Police:100
Ambulance:101
Police:200
Ambulance:201
but i want it like
Police:100
Ambulance:101
Emergency Police:200
Emergency Ambulance:201

here in the table i need to filter it based on slno also that i am not able to do.

Create Procedure test_Sp
As
Begin

insert into Test([col1],[col2])
select a.Name,b.sub
from IdTable b
join Nametable a ON b.no = a.no
where b.no like 'x_%'
end

the insert query works fine when executed but in sp it is not inserting 0 records.

Thanks Pradip Yeah the query has been solved.I had to apply left join.
But if the same query i am using in a store procedure it is not inserting any data.
Please help

Thanks Sandeep you code really works!!!

Yeah u rite Sandeep!! i waqnt to check for a dataset if that is empty then i dnt want to display Table in rdlc based on condition.

i want to check for dataset if it is empty .
please help

thanks buddy it works :)

yeah u rite its just logical coding i was making mistake in assigning path
Thanks buddy :)