ASP.NET

byte[] arrContent = null;
       DataTable dt = new DataTable();
       DataRow dr = default(DataRow);
       int id = Convert.ToInt32(Request.QueryString["id"]);
       //string username=Page.User.Identity.Name;
       //Getting the Image
       dt = PlayerInfo.ImagSelect(username);
       dr = dt.Rows[0];
       //storing it in array
       arrContent = (byte[])dr["photo"];
       int length = arrContent.Length;
       Response.ContentType = "image/JPEG";
       if (length!=0)
       Response.OutputStream.Write(arrContent, 0,length);
       Response.End();

ships_agr wrote:

i connected the adrotator to sqldatasource through a configure datasource wizard and when i tested the query there in wizard it worked f9...but on running the application no image is displayed in adrotator

Shrikant Kale wrote:

everytime I add new control I will need to change the code

Shrikant Kale wrote:

writing a code which will handle storing restoring values for each control

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

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

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;
    }