|
Combine the two PDFs using a .Net PDF manipulation library like iTextSharp.
|
|
|
|
|
Location_id Parent_id Location_name
29 3 Rahway, NJ (Time Zone:EST)
3 0 United States
30 29 126 E. Lincoln Avenue
5 3 North Wales, PA (Time Zone: EST)
6 3 Whitehouse Station, NJ (Time Zone: EST)
7 5 351 North Sumneytown Pike
8 7 Upper Gwynedd
31 30 Rahway
32 3 West Point, PA (Time Zone:EST)
11 6 One Merck Drive
12 11 Whitehouse Station
33 32 770 Sumneytown Pike
34 33 West Point
35 0 United Kingdom
36 0 Germany
37 36 Munich
38 37 85540 Haar
39 38 Lindenplatz 1
40 0 Japan
41 40 Tokyo
42 41 Chiyoda-ku
43 42 Kitanomaru Square
44 43 1-13-12 Kudan-kita-Room 1425-E
45 0 Singapore
46 45 #10-03/10 Parkview Square
47 46 600 North Bridge Road-188778
48 3 San Francisco, CA
49 48 Sirna-SF-314
50 0 Brazil
51 0 Italy
52 51 Rome
53 52 VIA PONTINA KM 30, 600
54 0 Canada
55 54 16711 TRANS-CANADA HIGHWAY
56 55 Montreal H9H 3L1
57 48 1700 Owens Street, 3rd Floor - 94158
58 3 Boston, MA (TimeZone:EST)
59 58 33 Avenue Louis Pasteur
60 59 Boston<pre>
question is how to get United States child location?
relation is,
United States ID is 3,
so find out all the parent_id with '3'
ex:[North Wales, PA (Time Zone: EST)] parent_id is '3' location_id is '5'
now if any location's parent_id is '5', then that is also UnitedSates children
<pre>
3 0 United States
5 3 North Wales, PA (Time Zone: EST)
6 3 Whitehouse Station, NJ (Time Zone: EST)
7 5 351 North Sumneytown Pike
8 7 Upper Gwynedd
how to get all the locations under 'United Sates'
icanmakeiteasy
|
|
|
|
|
U can try this
------------------
DECLARE @Location_ID INT
SELECT @Location_ID = 3
;WITH ret AS(
SELECT *
FROM Locations
WHERE Location_ID = @Location_ID
UNION ALL
SELECT t.*
FROM Locations t INNER JOIN
ret r ON t.Parent_ID = r.Location_ID
)
SELECT *
FROM ret
|
|
|
|
|
DECLARE @Location_ID INT
SELECT @Location_ID = 3
;WITH ret AS(
SELECT *
FROM Locations
WHERE Location_ID = @Location_ID
UNION ALL
SELECT t.*
FROM Locations t INNER JOIN
ret r ON t.Parent_ID = r.Location_ID
)
SELECT * FROM ret
icanmakeiteasy
|
|
|
|
|
Error here
Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'WITH'.
icanmakeiteasy
|
|
|
|
|
function asdf() {
getScrollHeight();
var obj = document.getElementById("popup");
obj.style.display = "block";
obj.style.top = getScrollHeight();
obj.style.left = 200;
}
function getScrollHeight() {
var h = window.pageYOffset ||
document.body.scrollTop ||
document.documentElement.scrollTop;
return h ? h : 0;
}
icanmakeiteasy
|
|
|
|
|
Hello -
I hope someone can help me with this. I have ajax modal popup extender, and when the popup will be open I want the surrounding of the window to be with black background. Can someone help me with that?
Thx, Laziale
|
|
|
|
|
Are you using the BackgroundCssClass property?
|
|
|
|
|
no i am not using background proprty how it use?
|
|
|
|
|
refer this and add style for the extender ...
http://www.asp.net/ajax/ajaxcontroltoolkit/Samples/ModalPopup/ModalPopup.aspx
|
|
|
|
|
Hi everybody, I made an application in asp.net using c# in vs 2003, so now we are using VS2008. In this application I have a class that generates charts and with the old framework everything worked fine, but now in the framework for vs 2008 it not runs! when I run the site and make the request of the chart I get the message below:
Failure Recovery COM class factory for component with CLSID (0002E55D-0000-0000-C000-000000000046) due to the following error: 80040154.
The class that generates charts does reference of Microsoft.Office.Interop.OWC11.dll, I've searched on other sites and discussion groups and not got a solution for my case ... Some say that I must register the dll, others say you should give access to the COM object clsid (0002E55D-0000-0000-C000-000000000046) ....
Anyone know something that can be done?
Thanks
Felipe, Brazil
|
|
|
|
|
|
hi iam using asp.net with c#
in my gridview 1st column is templatefield which contains check box control,
default i set to check, iam displaying data at page load event
but when i unchecked the checkbox then that row should be remove from gridview .
can you give me example which helps me
|
|
|
|
|
Check.. This may help you link
|
|
|
|
|
So for that, use rowcommand event and when user uncheck the checkbox then remove it from db and bind the grid again.
for details on rowcommand event, have a look to the link Click here
|
|
|
|
|
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox ck=(CheckBox)GridView1.Rows[i].Controls[0];
if(!ck.Check)
{
GridView1.Rows[i].visible=false;
}
}
modified 27-May-14 4:38am.
|
|
|
|
|
Dear All,
I am exporting grid view to excel using following code
void Export()
{
string attachment = "attachment; filename=Contacts.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
but what happens, It exports all the control to excel. I have button, listbox and other controls above my GridView but when exporting I want to export only my gridview to Excel
using above code all the page is exported,
any ideas how to export only gridview to excel?
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
Your code looks clean to me. It should work. Have you overridden VerifyRenderingInServerForm method?
public override void VerifyRenderingInServerForm(Control control)
{
}
|
|
|
|
|
I have already done that but no success.
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
|
thanks for your reply.
I have done the same thing, but all controls within the page are rendered and exported to excel file.
I want to export only the gridview not other controls.
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
Im looking for a interactive gannt control for my web app (something that mimics MS Project)
the only half decent control ive found is
http://www.plexityhide.com/[^]
but wanted to see it anyone else uses anything better?
thanks
|
|
|
|
|
Have a look on [Component Source]. You can usually download trail versions on components, to try before you buy.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Hello,
In my website I am maintaining log of users in which I am storing some user's information such as user machine IP number,SessionId,UserName etc.and able to show the list of current and past users in webpage.
I want to share a browser session of my current users.suppose there are many users who is accesing my site and if I click any perticular user then we can find the user's session and able to know the working of users.
Is it possiable,if yes then how ?
Please tell me......
Thanks to all.
modified on Tuesday, April 6, 2010 4:01 AM
|
|
|
|
|
Samarjeet Singh@india wrote: I want to share a browser session of my current users.suppose there are many users who is accesing my site and if I click any perticular user then we can find the user's session and able to know the working of users.
You cannot share other user's information from one session. May be try using Application object which can be shared across the users.
|
|
|
|