how do i use a photo slide show inside listview?
<p>how do i use a photo slide show inside listview??i am using jquery....the first row works fine..the pictures keep on looping...but in the next rows the pictures do not change..i mean its static...i am binding the image path from the columns"Image1" "Image2" "Image3".</p>

<pre><code>&lt;%@ Page Language="VB" AutoEventWireup="false" CodeFile="Restaurant.aspx.vb" Inherits="Restaurant" %&gt;

&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;

&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;
&lt;head runat="server"&gt;
    &lt;title&gt;&lt;/title&gt;
    &lt;link href="CSS_Styles/twoColFixLtHdr.css" rel="stylesheet" type="text/css" /&gt;
    &lt;script src="SpryAssets/SpryMenuBar.js" type="text/javascript"&gt;&lt;/script&gt;
    &lt;link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" /&gt;
    &lt;link href="CSS_Styles/Restaurant.css" rel="stylesheet" type="text/css" /&gt;
    &lt;script src="SpryAssets/jquery-1.4.4.min.js" type="text/javascript"&gt;&lt;/script&gt;
    &lt;script type="text/javascript"&gt;

        /*** 
        Simple jQuery Slideshow Script
        Released by Jon Raasch (jonraasch.com) under FreeBSD license: free to use or modify, not responsible for anything, etc.  Please link out to me if you like it :)
        ***/

        function slideSwitch() {
            var $active = $('#slideshow IMG.active');

            if ($active.length == 0) $active = $('#slideshow IMG:last');

            // use this to pull the images in the order they appear in the markup
            var $next = $active.next().length ? $active.next()
        : $('#slideshow IMG:first');

            // uncomment the 3 lines below to pull the images in random order

            // var $sibs  = $active.siblings();
            // var rndNum = Math.floor(Math.random() * $sibs.length );
            // var $next  = $( $sibs[ rndNum ] );


            $active.addClass('last-active');

            $next.css({ opacity: 0.0 })
        .addClass('active')
        .animate({ opacity: 1.0 }, 1000, function() {
            $active.removeClass('active last-active');
        });
        }

        $(function() {
            setInterval("slideSwitch()", 5000);
        });

&lt;/script&gt;
&lt;/head&gt;
&lt;body&gt;
    &lt;form id="form1" runat="server"&gt;
    &lt;div class="container"&gt;
  &lt;div class="header"&gt;
      &lt;asp:LoginStatus ID="LoginStatus1" runat="server" 
                                         ForeColor="White" 
                                         CssClass="signin" /&gt;
          &lt;asp:LoginView ID="LoginView1" runat="server"&gt;
          &lt;AnonymousTemplate&gt;
          &lt;asp:HyperLink ID="HyperLink1" runat="server" 
                                         CssClass="register" 
                                         ForeColor="White" 
                                         NavigateUrl="~/login.aspx"&gt;Register&lt;/asp:HyperLink&gt;
          &lt;asp:Label ID="Label2" runat="server"  
                                 ForeColor="White" 
                                 CssClass="welcome"&gt;Welcome!Guest.
          &lt;/asp:Label&gt;                                  
          &lt;/AnonymousTemplate&gt;
          &lt;LoggedInTemplate&gt;
          &lt;asp:HyperLink ID="HyperLink2" runat="server" 
                                         NavigateUrl="~/account.aspx" 
                                         ForeColor="White" 
                                         CssClass="myaccount" 
                                         ToolTip="Click here to go to your account page."&gt;My Account&lt;/asp:HyperLink&gt;
          &lt;asp:Label ID="Label2" runat="server"  
                                 ForeColor="White" 
                                 CssClass="welcome"&gt;Welcome!&lt;asp:LoginName ID="LoginName2" runat="server" /&gt;
          &lt;/asp:Label&gt;                         
          &lt;/LoggedInTemplate&gt;
          &lt;/asp:LoginView&gt;     
    &lt;!-- end .header --&gt;&lt;/div&gt;
&lt;div id="navPos"&gt;
    &lt;ul id="MenuBar1" class="MenuBarHorizontal"&gt;
  &lt;li&gt;
      &lt;asp:HyperLink ID="Home" runat="server" NavigateUrl="~/homepage_aspx/homepage.aspx"&gt;Home&lt;/asp:HyperLink&gt;
  &lt;/li&gt;
  &lt;li&gt;
      &lt;asp:HyperLink ID="Products" runat="server" CssClass="MenuBarItemSubmenu"&gt;Products&lt;/asp:HyperLink&gt;
      &lt;ul&gt;
      &lt;li&gt;&lt;asp:HyperLink ID="Groceries" runat="server"&gt;Groceries&lt;/asp:HyperLink&gt;&lt;/li&gt;
      &lt;li&gt;&lt;asp:HyperLink ID="DepartmentalItems" runat="server"&gt;Departmental Items&lt;/asp:HyperLink&gt;&lt;/li&gt;
      &lt;li&gt;&lt;asp:HyperLink ID="Electronics" runat="server"&gt;Electronics&lt;/asp:HyperLink&gt;
      &lt;ul&gt;
      &lt;li&gt;&lt;asp:HyperLink ID="Mobiles" runat="server" NavigateUrl="~/itemsDisplayPage_aspx/itemsDisplayPage.aspx?typeOfItem=mobiles"&gt;Mobiles&lt;/asp:HyperLink&gt;&lt;/li&gt;
      &lt;li&gt;&lt;asp:HyperLink ID="Laptops" runat="server" NavigateUrl="~/itemsDisplayPage_aspx/itemsDisplayPage.aspx?typeOfItem=computers"&gt;Laptops &amp;amp; Computers&lt;/asp:HyperLink&gt;&lt;/li&gt;
      &lt;li&gt;&lt;asp:HyperLink ID="Accessories" runat="server"&gt;Accessories&lt;/asp:HyperLink&gt;&lt;/li&gt;
      &lt;/ul&gt;      
      &lt;/li&gt;
      &lt;li&gt;&lt;asp:HyperLink ID="Kitchen" runat="server"&gt;Kitchen Items&lt;/asp:HyperLink&gt;&lt;/li&gt;
      &lt;li&gt;&lt;asp:HyperLink ID="HyperLink5" runat="server"&gt;HyperLink&lt;/asp:HyperLink&gt;&lt;/li&gt;
      &lt;li&gt;&lt;asp:HyperLink ID="HyperLink6" runat="server"&gt;HyperLink&lt;/asp:HyperLink&gt;&lt;/li&gt;
    &lt;/ul&gt;     
  &lt;/li&gt;
  &lt;li&gt;&lt;asp:HyperLink ID="WhyUS" runat="server"&gt;Why Us&lt;/asp:HyperLink&gt;&lt;/li&gt;
  &lt;li&gt;&lt;asp:HyperLink ID="Payment" runat="server"&gt;Payment&lt;/asp:HyperLink&gt;&lt;/li&gt;
  &lt;li&gt;&lt;asp:HyperLink ID="Contact_Us" runat="server" NavigateUrl="ContactUs.aspx"&gt;Contact Us&lt;/asp:HyperLink&gt;&lt;/li&gt;
  &lt;li&gt;&lt;asp:HyperLink ID="AboutUs" runat="server"&gt;About Us&lt;/asp:HyperLink&gt;&lt;/li&gt;
&lt;/ul&gt;


    &lt;/div&gt;&lt;br /&gt;&lt;br /&gt;

    &lt;div class="content1"&gt;
  &lt;div&gt;
      &amp;nbsp;&amp;nbsp;&lt;asp:SiteMapPath ID="SiteMapPath1" runat="server"&gt;
      &lt;/asp:SiteMapPath&gt;
  &lt;/div&gt;
            &lt;br /&gt;
       &lt;!-- &lt;div id="wrapper"&gt;

        &lt;div id="ResImage"&gt;

        &lt;/div&gt;
        &lt;div id="ResDesc"&gt;
            &lt;asp:Label ID="lblDesc" runat="server" Width="290px" Height="190px" BackColor="White"&gt;
                                                                                Pay Rs 499 for MAKEOVER PACKAGE: 
                                                                                Revival Facial, Haircut, Hair Wash, Blow Dry,
                                                                                Upper Lip &amp; Eyebrows Threading worth 
                                                                                Rs 1480 @ LAKME STUDIOS &amp; SALONS, DELHI &amp; NCR 
                                                                                (Valid at 16 outlets)&lt;/asp:Label&gt;

        &lt;/div&gt;
        &lt;div id="ResPrice1"&gt;
            &lt;asp:Label ID="lblValue" runat="server" Text="Value" CssClass="ResValue"&gt;&lt;/asp:Label&gt;
            &lt;asp:Label ID="lblDiscount" runat="server" Text="Discount" CssClass="ResDiscount"&gt;&lt;/asp:Label&gt;
            &lt;asp:Label ID="lblYouPay" runat="server" Text="You Pay" CssClass="ResYouPay"&gt;&lt;/asp:Label&gt;
        &lt;div id="ResPrice2"&gt;
            &lt;asp:Label ID="lblValueAmt" runat="server" Text="Rs.2000" CssClass="ResValueAmt"&gt;&lt;/asp:Label&gt;
            &lt;asp:Label ID="lblDiscountAmt" runat="server" Text="Rs.6000" CssClass="ResDiscountAmt"&gt;&lt;/asp:Label&gt;
            &lt;asp:Label ID="lblYouPayAmt" runat="server" Text="Rs.1400" CssClass="ResYouPayAmt"&gt;&lt;/asp:Label&gt;
        &lt;/div&gt;
            &lt;asp:LinkButton ID="lnkGetCoupon" runat="server"&gt;Get Discount Coupon&lt;/asp:LinkButton&gt;
        &lt;/div&gt;

        &lt;div id="HowItWorks"&gt;
            &lt;asp:Label ID="lblHowItWorks" runat="server" Text="How It Works?" Font-Bold="True" Font-Size="Small" ForeColor="Red"&gt;&lt;/asp:Label&gt;
            &lt;ul&gt;
            &lt;li&gt;&lt;asp:Label ID="Label3" runat="server" Text="1.Click on the 'Get Discount Coupon' button" Font-Size="10px"&gt;&lt;/asp:Label&gt;&lt;/li&gt;
            &lt;li&gt;&lt;asp:Label ID="Label4" runat="server" Text="2.Get a print of your Voucher and carry it during your visit to the outlet." Font-Size="10px"&gt;&lt;/asp:Label&gt;&lt;/li&gt;
            &lt;li&gt;&lt;asp:Label ID="Label5" runat="server" Text="3.Show your Voucher and pay the amount directly to the merchant. " Font-Size="10px"&gt;&lt;/asp:Label&gt;&lt;/li&gt;
            &lt;/ul&gt;
        &lt;/div&gt;


        &lt;/div&gt; --&gt;

        &lt;asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource1" 
            DataKeyNames="OfferID" GroupItemCount="2" &gt;
            &lt;EmptyDataTemplate&gt;
                &lt;table runat="server" style=""&gt;
                    &lt;tr&gt;
                        &lt;td&gt;
                            No data was returned.&lt;/td&gt;
                    &lt;/tr&gt;
                &lt;/table&gt;
            &lt;/EmptyDataTemplate&gt;
            &lt;InsertItemTemplate&gt;
                &lt;td runat="server" style=""&gt;
                    OfferID:
                    &lt;asp:TextBox ID="OfferIDTextBox" runat="server" Text='&lt;%# Bind("OfferID") %&gt;' /&gt;
                    &lt;br /&gt;
                    RestaurantID:
                    &lt;asp:TextBox ID="RestaurantIDTextBox" runat="server" 
                        Text='&lt;%# Bind("RestaurantID") %&gt;' /&gt;
                    &lt;br /&gt;
                    Offer:
                    &lt;asp:TextBox ID="OfferTextBox" runat="server" Text='&lt;%# Bind("Offer") %&gt;' /&gt;
                    &lt;br /&gt;
                    Value:
                    &lt;asp:TextBox ID="ValueTextBox" runat="server" Text='&lt;%# Bind("Value") %&gt;' /&gt;
                    &lt;br /&gt;
                    Discount:
                    &lt;asp:TextBox ID="DiscountTextBox" runat="server" 
                        Text='&lt;%# Bind("Discount") %&gt;' /&gt;
                    &lt;br /&gt;
                    YouPay:
                    &lt;asp:TextBox ID="YouPayTextBox" runat="server" Text='&lt;%# Bind("YouPay") %&gt;' /&gt;
                    &lt;br /&gt;
                    &lt;asp:Button ID="InsertButton" runat="server" CommandName="Insert" 
                        Text="Insert" /&gt;
                    &lt;br /&gt;
                    &lt;asp:Button ID="CancelButton" runat="server" CommandName="Cancel" 
                        Text="Clear" /&gt;
                    &lt;br /&gt;
                &lt;/td&gt;
            &lt;/InsertItemTemplate&gt;
       &lt;LayoutTemplate&gt;
           &lt;table runat="server"&gt;
               &lt;tr runat="server"&gt;
                   &lt;td runat="server"&gt;
                       &lt;table ID="groupPlaceholderContainer" runat="server" border="0" style=""&gt;
                           &lt;tr ID="groupPlaceholder" runat="server"&gt;
                           &lt;/tr&gt;
                       &lt;/table&gt;
                   &lt;/td&gt;
               &lt;/tr&gt;
               &lt;tr runat="server"&gt;
                   &lt;td runat="server" style=""&gt;
                   &lt;/td&gt;
               &lt;/tr&gt;
           &lt;/table&gt;

       &lt;/LayoutTemplate&gt;
            &lt;EmptyItemTemplate&gt;
                &lt;td runat="server" /&gt;
                &lt;/EmptyItemTemplate&gt;
       &lt;ItemTemplate&gt;
           &lt;td runat="server" style=""&gt;

               &lt;div id="wrapper"&gt;

        &lt;div id="ResImage"&gt;


&lt;div id="slideshow"&gt;

    &lt;asp:Image ID="Image1" runat="server" ImageUrl='&lt;%# Eval ("Image1") %&gt;' Width="250px" Height="190px" CssClass="active" /&gt;
    &lt;asp:Image ID="Image5" runat="server" ImageUrl='&lt;%# Eval ("Image2") %&gt;' Width="250px" Height="190px" /&gt;
    &lt;asp:Image ID="Image4" runat="server" ImageUrl='&lt;%# Eval ("Image3") %&gt;' Width="250px" Height="190px" /&gt;


&lt;/div&gt;

        &lt;/div&gt;
        &lt;div id="ResDesc"&gt;
            &lt;asp:Label ID="lblDesc" runat="server" Width="290px" Height="190px" BackColor="White" Text='&lt;%# Eval("Offer") %&gt;'&gt;&lt;/asp:Label&gt;

        &lt;/div&gt;
        &lt;div id="ResPrice1"&gt;
            &lt;asp:Label ID="lblValue" runat="server" Text="Value" CssClass="ResValue"&gt;&lt;/asp:Label&gt;
            &lt;asp:Label ID="lblDiscount" runat="server" Text="Discount" CssClass="ResDiscount"&gt;&lt;/asp:Label&gt;
            &lt;asp:Label ID="lblYouPay" runat="server" Text="You Pay" CssClass="ResYouPay"&gt;&lt;/asp:Label&gt;
        &lt;div id="ResPrice2"&gt;
            &lt;asp:Label ID="lblValueAmt" runat="server" Text='&lt;%# Eval("Value") %&gt;' CssClass="ResValueAmt"&gt;&lt;/asp:Label&gt;
            &lt;asp:Label ID="lblDiscountAmt" runat="server" Text='&lt;%# Eval("Discount") %&gt;' CssClass="ResDiscountAmt"&gt;&lt;/asp:Label&gt;
            &lt;asp:Label ID="lblYouPayAmt" runat="server" Text='&lt;%# Eval("YouPay") %&gt;' CssClass="ResYouPayAmt"&gt;&lt;/asp:Label&gt;
        &lt;/div&gt;
            &lt;asp:Label ID="lblRestaurantName" runat="server" Text='&lt;%# Eval("RestaurantName") %&gt;'&gt;&lt;/asp:Label&gt;&lt;br /&gt;
            &lt;asp:LinkButton ID="lnkGetCoupon" runat="server"&gt;Get Discount Coupon&lt;/asp:LinkButton&gt;
        &lt;/div&gt;

        &lt;div id="HowItWorks"&gt;
            &lt;asp:Label ID="lblHowItWorks" runat="server" Text="How It Works?" Font-Bold="True" Font-Size="Small" ForeColor="Red"&gt;&lt;/asp:Label&gt;
            &lt;ul&gt;
            &lt;li&gt;&lt;asp:Label ID="Label3" runat="server" Text="1.Click on the 'Get Discount Coupon' button" Font-Size="10px"&gt;&lt;/asp:Label&gt;&lt;/li&gt;
            &lt;li&gt;&lt;asp:Label ID="Label4" runat="server" Text="2.Get a print of your Voucher and carry it during your visit to the outlet." Font-Size="10px"&gt;&lt;/asp:Label&gt;&lt;/li&gt;
            &lt;li&gt;&lt;asp:Label ID="Label5" runat="server" Text="3.Show your Voucher and pay the amount directly to the merchant. " Font-Size="10px"&gt;&lt;/asp:Label&gt;&lt;/li&gt;
            &lt;/ul&gt;
        &lt;/div&gt;


        &lt;/div&gt;
           &lt;/td&gt;
       &lt;/ItemTemplate&gt;
       &lt;AlternatingItemTemplate&gt;
           &lt;td runat="server" style=""&gt;

               &lt;div id="wrapper"&gt;

        &lt;div id="ResImage"&gt;
        &lt;div id="slideshow"&gt;
            &lt;asp:Image ID="Image1" runat="server" ImageUrl='&lt;%# Eval ("Image1") %&gt;' Width="250px" Height="190px" CssClass="active" /&gt;
            &lt;asp:Image ID="Image5" runat="server" ImageUrl='&lt;%# Eval ("Image2") %&gt;' Width="250px" Height="190px" /&gt;
            &lt;asp:Image ID="Image4" runat="server" ImageUrl='&lt;%# Eval ("Image3") %&gt;' Width="250px" Height="190px" /&gt;
        &lt;/div&gt;
        &lt;/div&gt;
        &lt;div id="ResDesc"&gt;
            &lt;asp:Label ID="lblDesc" runat="server" Width="290px" Height="190px" BackColor="White" Text='&lt;%# Eval("Offer") %&gt;'&gt;&lt;/asp:Label&gt;

        &lt;/div&gt;
        &lt;div id="ResPrice1"&gt;
            &lt;asp:Label ID="lblValue" runat="server" Text="Value" CssClass="ResValue"&gt;&lt;/asp:Label&gt;
            &lt;asp:Label ID="lblDiscount" runat="server" Text="Discount" CssClass="ResDiscount"&gt;&lt;/asp:Label&gt;
            &lt;asp:Label ID="lblYouPay" runat="server" Text="You Pay" CssClass="ResYouPay"&gt;&lt;/asp:Label&gt;
        &lt;div id="ResPrice2"&gt;
            &lt;asp:Label ID="lblValueAmt" runat="server" Text='&lt;%# Eval("Value") %&gt;' CssClass="ResValueAmt"&gt;&lt;/asp:Label&gt;
            &lt;asp:Label ID="lblDiscountAmt" runat="server" Text='&lt;%# Eval("Discount") %&gt;' CssClass="ResDiscountAmt"&gt;&lt;/asp:Label&gt;
            &lt;asp:Label ID="lblYouPayAmt" runat="server" Text='&lt;%# Eval("YouPay") %&gt;' CssClass="ResYouPayAmt"&gt;&lt;/asp:Label&gt;
        &lt;/div&gt;
            &lt;asp:Label ID="lblRestaurantName" runat="server" Text='&lt;%# Eval("RestaurantName") %&gt;'&gt;&lt;/asp:Label&gt;&lt;br /&gt;
            &lt;asp:LinkButton ID="lnkGetCoupon" runat="server"&gt;Get Discount Coupon&lt;/asp:LinkButton&gt;
        &lt;/div&gt;

        &lt;div id="HowItWorks"&gt;
            &lt;asp:Label ID="lblHowItWorks" runat="server" Text="How It Works?" Font-Bold="True" Font-Size="Small" ForeColor="Red"&gt;&lt;/asp:Label&gt;
            &lt;ul&gt;
            &lt;li&gt;&lt;asp:Label ID="Label3" runat="server" Text="1.Click on the 'Get Discount Coupon' button" Font-Size="10px"&gt;&lt;/asp:Label&gt;&lt;/li&gt;
            &lt;li&gt;&lt;asp:Label ID="Label4" runat="server" Text="2.Get a print of your Voucher and carry it during your visit to the outlet." Font-Size="10px"&gt;&lt;/asp:Label&gt;&lt;/li&gt;
            &lt;li&gt;&lt;asp:Label ID="Label5" runat="server" Text="3.Show your Voucher and pay the amount directly to the merchant. " Font-Size="10px"&gt;&lt;/asp:Label&gt;&lt;/li&gt;
            &lt;/ul&gt;
        &lt;/div&gt;


        &lt;/div&gt;
           &lt;/td&gt;
       &lt;/AlternatingItemTemplate&gt;
                &lt;EditItemTemplate&gt;
                    &lt;td runat="server" style=""&gt;
                        OfferID:
                        &lt;asp:Label ID="OfferIDLabel1" runat="server" Text='&lt;%# Eval("OfferID") %&gt;' /&gt;
                        &lt;br /&gt;
                        RestaurantID:
                        &lt;asp:TextBox ID="RestaurantIDTextBox" runat="server" 
                            Text='&lt;%# Bind("RestaurantID") %&gt;' /&gt;
                        &lt;br /&gt;
                        Offer:
                        &lt;asp:TextBox ID="OfferTextBox" runat="server" Text='&lt;%# Bind("Offer") %&gt;' /&gt;
                        &lt;br /&gt;
                        Value:
                        &lt;asp:TextBox ID="ValueTextBox" runat="server" Text='&lt;%# Bind("Value") %&gt;' /&gt;
                        &lt;br /&gt;
                        Discount:
                        &lt;asp:TextBox ID="DiscountTextBox" runat="server" 
                            Text='&lt;%# Bind("Discount") %&gt;' /&gt;
                        &lt;br /&gt;
                        YouPay:
                        &lt;asp:TextBox ID="YouPayTextBox" runat="server" Text='&lt;%# Bind("YouPay") %&gt;' /&gt;
                        &lt;br /&gt;
                        &lt;asp:Button ID="UpdateButton" runat="server" CommandName="Update" 
                            Text="Update" /&gt;
                        &lt;br /&gt;
                        &lt;asp:Button ID="CancelButton" runat="server" CommandName="Cancel" 
                            Text="Cancel" /&gt;
                        &lt;br /&gt;
                    &lt;/td&gt;
                &lt;/EditItemTemplate&gt;
                &lt;GroupTemplate&gt;
                    &lt;tr ID="itemPlaceholderContainer" runat="server"&gt;
                        &lt;td ID="itemPlaceholder" runat="server"&gt;
                        &lt;/td&gt;
                    &lt;/tr&gt;
                &lt;/GroupTemplate&gt;
                &lt;SelectedItemTemplate&gt;
                    &lt;td runat="server" style=""&gt;
                        OfferID:
                        &lt;asp:Label ID="OfferIDLabel" runat="server" Text='&lt;%# Eval("OfferID") %&gt;' /&gt;
                        &lt;br /&gt;
                        RestaurantID:
                        &lt;asp:Label ID="RestaurantIDLabel" runat="server" 
                            Text='&lt;%# Eval("RestaurantID") %&gt;' /&gt;
                        &lt;br /&gt;
                        Offer:
                        &lt;asp:Label ID="OfferLabel" runat="server" Text='&lt;%# Eval("Offer") %&gt;' /&gt;
                        &lt;br /&gt;
                        Value:
                        &lt;asp:Label ID="ValueLabel" runat="server" Text='&lt;%# Eval("Value") %&gt;' /&gt;
                        &lt;br /&gt;
                        Discount:
                        &lt;asp:Label ID="DiscountLabel" runat="server" Text='&lt;%# Eval("Discount") %&gt;' /&gt;
                        &lt;br /&gt;
                        YouPay:
                        &lt;asp:Label ID="YouPayLabel" runat="server" Text='&lt;%# Eval("YouPay") %&gt;' /&gt;
                        &lt;br /&gt;
                    &lt;/td&gt;
                &lt;/SelectedItemTemplate&gt;
        &lt;/asp:ListView&gt;



        &lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="&lt;%$ ConnectionStrings:databaseConnectionString %&gt;" 

                SelectCommand="SELECT RestaurantOffers.RestaurantID, RestaurantOffers.Offer, RestaurantOffers.Value, RestaurantOffers.Discount, RestaurantOffers.YouPay, RestaurantName.RestaurantName, RestaurantName.Address, RestaurantName.PhoneNumber, RestaurantName.Image1, RestaurantName.Image2, RestaurantName.Image3, RestaurantOffers.OfferID FROM RestaurantName INNER JOIN RestaurantOffers ON RestaurantName.RestaurantID = RestaurantOffers.RestaurantID ORDER BY NEWID() " 
                ConflictDetection="CompareAllValues" 
                DeleteCommand="DELETE FROM [RestaurantOffers] WHERE [OfferID] = @original_OfferID AND [RestaurantID] = @original_RestaurantID AND (([Offer] = @original_Offer) OR ([Offer] IS NULL AND @original_Offer IS NULL)) AND (([Value] = @original_Value) OR ([Value] IS NULL AND @original_Value IS NULL)) AND (([Discount] = @original_Discount) OR ([Discount] IS NULL AND @original_Discount IS NULL)) AND (([YouPay] = @original_YouPay) OR ([YouPay] IS NULL AND @original_YouPay IS NULL))" 
                InsertCommand="INSERT INTO [RestaurantOffers] ([OfferID], [RestaurantID], [Offer], [Value], [Discount], [YouPay]) VALUES (@OfferID, @RestaurantID, @Offer, @Value, @Discount, @YouPay)" 
                OldValuesParameterFormatString="original_{0}" 
                UpdateCommand="UPDATE [RestaurantOffers] SET [RestaurantID] = @RestaurantID, [Offer] = @Offer, [Value] = @Value, [Discount] = @Discount, [YouPay] = @YouPay WHERE [OfferID] = @original_OfferID AND [RestaurantID] = @original_RestaurantID AND (([Offer] = @original_Offer) OR ([Offer] IS NULL AND @original_Offer IS NULL)) AND (([Value] = @original_Value) OR ([Value] IS NULL AND @original_Value IS NULL)) AND (([Discount] = @original_Discount) OR ([Discount] IS NULL AND @original_Discount IS NULL)) AND (([YouPay] = @original_YouPay) OR ([YouPay] IS NULL AND @original_YouPay IS NULL))"&gt;
            &lt;DeleteParameters&gt;
                &lt;asp:Parameter Name="original_OfferID" Type="String" /&gt;
                &lt;asp:Parameter Name="original_RestaurantID" Type="String" /&gt;
                &lt;asp:Parameter Name="original_Offer" Type="String" /&gt;
                &lt;asp:Parameter Name="original_Value" Type="String" /&gt;
                &lt;asp:Parameter Name="original_Discount" Type="String" /&gt;
                &lt;asp:Parameter Name="original_YouPay" Type="String" /&gt;
            &lt;/DeleteParameters&gt;
            &lt;UpdateParameters&gt;
                &lt;asp:Parameter Name="RestaurantID" Type="String" /&gt;
                &lt;asp:Parameter Name="Offer" Type="String" /&gt;
                &lt;asp:Parameter Name="Value" Type="String" /&gt;
                &lt;asp:Parameter Name="Discount" Type="String" /&gt;
                &lt;asp:Parameter Name="YouPay" Type="String" /&gt;
                &lt;asp:Parameter Name="original_OfferID" Type="String" /&gt;
                &lt;asp:Parameter Name="original_RestaurantID" Type="String" /&gt;
                &lt;asp:Parameter Name="original_Offer" Type="String" /&gt;
                &lt;asp:Parameter Name="original_Value" Type="String" /&gt;
                &lt;asp:Parameter Name="original_Discount" Type="String" /&gt;
                &lt;asp:Parameter Name="original_YouPay" Type="String" /&gt;
            &lt;/UpdateParameters&gt;
            &lt;InsertParameters&gt;
                &lt;asp:Parameter Name="OfferID" Type="String" /&gt;
                &lt;asp:Parameter Name="RestaurantID" Type="String" /&gt;
                &lt;asp:Parameter Name="Offer" Type="String" /&gt;
                &lt;asp:Parameter Name="Value" Type="String" /&gt;
                &lt;asp:Parameter Name="Discount" Type="String" /&gt;
                &lt;asp:Parameter Name="YouPay" Type="String" /&gt;
            &lt;/InsertParameters&gt;
            &lt;/asp:SqlDataSource&gt;



  &lt;!-- end .content --&gt;&lt;/div&gt;
  &lt;div class="footer"&gt;

    &lt;!-- end .footer --&gt;&lt;/div&gt;
  &lt;!-- end .container --&gt;&lt;/div&gt;
  &lt;script type="text/javascript"&gt;
      var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", { imgDown: "SpryAssets/SpryMenuBarDownHover.gif", imgRight: "SpryAssets/SpryMenuBarRightHover.gif" });
&lt;/script&gt;
    &lt;/form&gt;
&lt;/body&gt;
&lt;/html&gt;
</code></pre>
