|
Hi i am having multiple datatables inmy dataset...,
I want to write each datatble datas in different different excel files...,
How to do that,..
Any one have idea
plz forward to me...,
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
Did you tried anything.
Because its not that much difficult to convert a data table to excel.
Search 'google' you will get lots of samples.Try it out and if you are stuck somewhere, come back.
Somebody is rating down your questions, do you know why?
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|
|
No i didnt get last 2 days i am tryiing for that......,
My problem is each datatble have to write in different different excel files...,
If u have any links to create multiple excel file in runtime ans save the datatable datas in that plz forward to me................,
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
1[^]
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|
|
Ya but they bind all the datatables in same excel file different different sheets...,
but i want bind each datatable in different different excel sheets
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
You wont get the complete code for such things,Sir...
You will get an idea from that article, and you should develop the rest..
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|
|
I hope you are only doing this as a school project or something. You have been given loads of help and yet you still don't want to actually think for yourself.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi!
I'm new in linq. Please, show me, what's wrong with my linq query. I have table "customers", that has association with table "Country", and entity classes according to these table, I try to select country name and count of all customers from this country:
CustomerDataContext dc = new CustomerDataContext();
var query = from p in dc.customers
where p.Country.cname =="USA"
group p by p.Country.cname into result
select new
{
country = result.Country.cname,
total = result.Count()
};
Compiler error message:
'System.Linq.IGrouping<string,customer>' does not contain a definition for 'Country' and no extension method 'Country' accepting a first argument of type 'System.Linq.IGrouping<string,customer>' could be found (are you missing a using directive or an assembly reference?)
Thanks in advance!
|
|
|
|
|
|
it's country name i want to get("USA")
|
|
|
|
|
yeah but its saying
"it does not contain a definition for 'Country'"
that means you need to either define it or it doesnt exist
|
|
|
|
|
But, when i try to execute simple query, it works:
var query = from p in dc.customers
select new
{
p.Country.cname,
p.name
};
|
|
|
|
|
Hi all
I want to disable the TreeNode tooltip of the treeview control. I have a user control which I load into asp.net wizard. I create the nodes dynamically. I tried with windows.attachEvent() but I found that the specified treeview object is not available onLoad.
Is there any way I can set the disable the treenode checkbox's tooltip at server side?
Or is it possible to set the mouseover event for the checkbox of tree node? Please guide me.
any other suggestions are also welcome.
|
|
|
|
|
Hi
I have recently added an update panel to my page.
All the code that I did have on my page load is now in my button which is the trigger for the update panel.
The problem is, on page load it still runs the query
How can I fix this?
|
|
|
|
|
OK now I have a different problem
Basically I have the query in my button event.
This query can select all fields but can also be narrowed down by search criteria
I store the sessions for the search criteria in the button event.
If I type in some search criteria and click search the first time it brings up all results not using the search criteria but the 2nd time it brings up the correct results accoridng to my search criteria.
Why do I need to click the button twice?
thanks! 
|
|
|
|
|
May be you are setting the search criteria at button click event,
Can you show some code?
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|
|
I've fixed it now.
Basically I was checking the lenght of a string before I ran the query but the string was set on the page load therefore it took two click to get to it.
Thanks anyway
|
|
|
|
|
Hi guys i am facing problem in nested cursor...,
In this first cursor for managers and second one is for employee details...,
Its going on well..,
But the employee detail it binding the all the managers, last record of employee at 2 times...,
but i want to bind those also at one time...,
See i given my procedure on down side:
pLz tell me what wrong in that?,
DECLARE curMgr CURSOR FOR
SELECT distinct ManagerID FROM @tbl_TempManagers
OPEN curMgr
FETCH NEXT FROM curMgr INTO @mgID
Insert Into @tbl_TempEmployee Select MId,ID,UserName,EId from tbl_login Where Mid=@mgid
WHILE (@@FETCH_STATUS = 0 )
BEGIN
SET @EmpDetail = ''
SELECT @Count=Count(*) FROM @tbl_TempEmployee
--
SET @Counter=1
DECLARE curDetailList CURSOR FOR
SELECT distinct EmployeeName from @tbl_Tempemployee where ManagerId = @mgID
OPEN curDetailList
FETCH NEXT FROM curDetailList INTO @EmployeeName1
SELECT
convert(varchar(20),TSDate,101) as [Date],TSSubject as [Subject],TSDescription as [Description],
TSHour as [Hour],TSMin as [Minute],convert(varchar(20),CreationDate,101) as [Creation Date],
CreationBy as [Name Of Employee] FROM tbl_TSEnterData where CreationBy=@employeename1
AND TSDate BETWEEN
CONVERT( NVARCHAR, DATEADD(wk, -1, @d) , 101) AND CONVERT( NVARCHAR, DATEADD(dd, -1, @d) , 101)
order by CreationBy asc,TSDate Desc
WHILE (@@FETCH_STATUS = 0 AND @Counter<@Count)
BEGIN
SET @EmpDetail = @EmpDetail + @EmployeeName1 + ', '
FETCH NEXT FROM curDetailList INTO @EmployeeName1
SELECT
convert(varchar(20),TSDate,101) as [Date],TSSubject as [Subject],TSDescription as [Description],
TSHour as [Hour],TSMin as [Minute],convert(varchar(20),CreationDate,101) as [Creation Date],
CreationBy as [Name Of Employee] FROM tbl_TSEnterData where CreationBy=@employeename1
AND TSDate BETWEEN
CONVERT( NVARCHAR, DATEADD(wk, -1, @d) , 101) AND CONVERT( NVARCHAR, DATEADD(dd, -1, @d) , 101)
order by CreationBy asc,TSDate Desc
SET @counter=@counter+1
END
CLOSE curDetailList
DEALLOCATE curDetailList
INSERT INTO @Result VALUES (@mgID, @EmpDetail)
FETCH NEXT FROM curmgr INTO @mgID
Insert Into @tbl_TempEmployee Select MId,ID,UserName,EId from tbl_login Where Mid=@mgid
END
CLOSE curmgr
DEALLOCATE curmgr
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
This is Asp.NET Forum. Please Put it on SQL Forum to get right answer.
cheers,
Abhijit
|
|
|
|
|
Post your questions in the correct forum.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
Hi to everyone,
I'm trying to write a code for a webcam that is able to take picture from the web-site, web based. Meaning the person open the web site and it can use the webcam on it's own PC to take a photo of him/her-self. I'm using both asp.net and VB to do this. The area i'm stuck in is the getting to use the webcam in web-base. How can i go around doing this?
Thanks in advance
Max
|
|
|
|
|
max_sp07 wrote: I'm trying to write a code for a webcam that is able to take picture from the web-site
You are totally lost. Web application can't interact with web cam and take photos.
|
|
|
|
|
Accessing the webcam means accessin the computer resources which is impossible through ASP.net
You need to create an ActiveX control (preferably built on VB6) in order to capture the photos
Best Regards
3ala2 
|
|
|
|
|
just3ala2 wrote: Accessing the webcam means accessin the computer resources which is impossible through ASP.net
You need to create an ActiveX control (preferably built on VB6) in order to capture the photos
Hi to 3ala2,
Can u help me by providing the code for it. Really don't know how to do it. Or do u have any reference for it, so i can study on it.
Million of Thanks.
Max
|
|
|
|
|
Hi all,
I am adding 3 session variables in login page. These session variables are added when user logins into website.
All these session variables i am using almost in all the pages to retrive the information from database based on the session variables.
And also i am using these session variables in master page.
I set session timeout to 60 min in web.config.
The problem is when ever i submit data of page to server , the old session variables are lost. The new session is started.
But i have to keep old session variable until user logouts from the website...
Please help me.. How to do that...
Thanks in advance.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
