Feed on
Posts
Comments

Archive for October, 2007

Move Items From One ListBox To Another

Posted in .Net, ASP.Net, C#, HTML, JavaScript, Uncategorized on October 25, 2007 | No Comments »

<%@ 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”>
<html xmlns=”http://www.w3.org/1999/xhtml”>
<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 [...]

Read Full Post »

Case Statement In SQL

Posted in SQL, Uncategorized on October 25, 2007 | No Comments »

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

Read Full Post »

Insert Statement And Return Identity

Posted in SQL, Uncategorized on October 25, 2007 | No Comments »

INSERT SomeTable
(
  @SomeColumn1,
  @SomeColumn2
)
VALUES
(
  @SomeParameter1,
  @SomeParameter2
)
SELECT IDENT_CURRENT(‘SomeTable’ ;)

Read Full Post »

Creating A Temp Table In SQL

Posted in SQL, Uncategorized on October 25, 2007 | No Comments »

CREATE TABLE #TempTable
( 
  SomeColumn1 INT,
  SomeColumn2 VARCHAR(50)
)
INSERT INTO #TempTable
SELECT SomeColumn3, SomeColumn4 FROM SomeTable WHERE SomeColumn5 = @SomeParameter
DROP TABLE #TempTable

Read Full Post »

Set A Variable In A Stored Procedure From A Select Statement

Posted in SQL, Uncategorized on October 25, 2007 | No Comments »

DECLARE @Value
INSERT @Value = (SELECT SomeColumn1 FROM SomeTable WHERE SomeColumn2 = @SomeParameter)

Read Full Post »