Move Items From One ListBox To Another

<%@ Page Language=”C#” AutoEventWireup=”true” CodeFile=”Default.aspx.cs” Inherits=”_Default” %>

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

<html xmlns=”http://www.w3.org/1999/xhtml”&gt;

<head runat=”server”>

<title>Untitled Page</title>

</head>

<body>

<form id=”form1″ runat=”server”>

<div>

<asp:ListBox ID=”LBSource” SelectionMode=”Multiple” runat=”server”>

  <asp:ListItem Text=”Item1″ Value=”vItem1″></asp:ListItem>

  <asp:ListItem Text=”Item2″ Value=”vItem2″></asp:ListItem>

  <asp:ListItem Text=”Item3″ Value=”vItem3″></asp:ListItem>

  <asp:ListItem Text=”Item4″ Value=”vItem4″></asp:ListItem>

  <asp:ListItem Text=”Item5″ Value=”vItem5″></asp:ListItem>

</asp:ListBox>

<input type=”button” value=”Add” onclick=”moveItems(‘<%= LBSource.ClientID %>‘, ‘<%= LBDestination.ClientID %>‘)” />

<input type=”button” value=”Remove” onclick=”moveItems(‘<%= LBDestination.ClientID %>‘, ‘<%= LBSource.ClientID %>‘)” />

<asp:ListBox ID=”LBDestination” SelectionMode=”Multiple” runat=”server”></asp:ListBox>

</div>

</form>

<script language=”javascript” type=”text/javascript”>

function moveItems(srcID, dstID)

{

  src = document.getElementById(srcID);

  dst = document.getElementById(dstID); var found = true;

  while (found)

  {

    found = false;

    for (var i = 0; i < src.length; i++)

    {

      if (src[i].selected)

      {

        dst.appendChild(src[i].cloneNode(true));

        src.removeChild(src[i]);

        found = true;

        break;

      }

    }

  }

}

</script>

</body>

</html>

Advertisements

Case Statement In SQL

SELECT SomeColumn1 =

(

  SELECT

    CASE

      WHEN SomeColumn3 IS NULL THEN ISNULL(SomeColumn3,)

      ELSE ISNULL(SomeColumn4,)

    END

  FROM SomeTable2 WHERE SomeColumn5 = @SomeParameter2

)

FROM SomeTable1

WHERE SomeColumn2 = @SomeParameter1