VB.NET – SQL statement “LIKE”

January 16, 2012 - Posted in Access, Applications, ASP.NET, SQL - Permalink
Input box

Please enter customer first or last name:
<asp:RequiredFieldValidator ID="ReqSearchfor" runat="server"
    ErrorMessage="<font color='red'>Input box can not be empty!</font>"
    ControlToValidate="SearchFor" >
<asp:TextBox ID="SearchFor" runat="server">
<asp:Button ID="SearchBtn" runat="server" Text="Search" />


SQL DataSource Design

<asp:SqlDataSource ID="SearchResults"
        runat="server" ConnectionString="< %$ myConString %>"
        SelectCommand="SELECT * FROM [CustomerTbl] WHERE
                      ([customer_name] LIKE '%' + @customer_name + '%')"
        <SelectParameters>
             <asp:ControlParameter ControlID="SearchFor" Name="customer_name"
                 PropertyName="Text" Type="String" />
        </SelectParameters>
</asp:SqlDataSource>

CSS Horizontal Navigation Menu

January 3, 2012 - Posted in Applications - Permalink
CSS code - horizontal navigation menu


/* 'defines width, font and position */
#nav {
  font-family: verdana, sans-serif;
  position: relative;
  width: 100%;
  font-size:11px;
  color:#FFF;
  padding-top: 0px;
}
/* 'defines list type */
#nav ul {
  list-style-type: none;
  background-color: #000;
}
/* 'defines the drop-down container */
#nav ul li {
  float: left;
  position: relative;
  height: 18px;
}
/* defines text property of main menu links */
#nav ul li a {
  text-align: center;
  border-right: 0px solid #e9e9e9;
  padding: 2px 6px 2px 6px;
  display:block;
  text-decoration:none;
  color:#FFF;
}
/* 'defines hover properties of main menu links */
#nav ul li a:hover {
  text-align: center;
  border-right: 0px solid #e9e9e9;
  padding: 1px 6px 3px 6px;
  display:block;
  text-decoration: none;
  color:#F1ECAB; height: 15px;
  background-color: #115498;
  border-top: 1px solid #F8F8F8;
}
/* 'hides sub-menu */
#nav ul li ul {
  display: none;
}
/* 'defines sub-menu ul properties */
#nav ul li:hover ul {
  display: block;
  position: absolute;
  margin-top: 0px;
  background: #F8F8F8;
}
/* 'defines sub-menu container properties on main menu link mouse-over */
#nav ul li:hover ul li a {
  margin-left: -40px;
  margin-top: -4px;
  display:block;
  height: 22px;
  background: #F8F8F8;
  color: #000;
  width: 100px;
  text-align: left;
  border-bottom: 1px solid #DFDFDF;
  border-left: 1px solid #DFDFDF;
  border-right: 1px solid #DFDFDF;
}
/*'defines sub-menu hover bgr and link color */
#nav ul li:hover ul li a:hover {
  margin-left: -40px;
  height: 22px;
  background: #F8F8F8;
  color: #115498;
  text-decoration: underline;
  padding: -5px 0 10px 0;
}


HTML code

<div id="nav">
    <ul>
        <li class="first"><a href="#>Home</a></li>
        <li><a href="#">About Us</a>
        <ul>
            <li><a href="#">Location</a></li>
            <li><a href="#">Staff</a></li>
            <li><a href="#">Partners</a></li>
        </ul>
        </li>
        <li><a href="#">Forms
        <ul>
            <li><a href="#">Web</a></li>
            <li><a href="#">Print</a></li>
            <li><a href="#">Photos</a></li>
        </ul>
        </li>
        <li><a href="#">Information
        <ul>
            <li><a href="#">Contact</a></li>
            <li><a href="#">Services</a></li>
            <li><a href="#">Prices</a></li>
        </ul>
        </li>
    </ul>

Drop-down onChange event

December 21, 2011 - Posted in Applications, ASP.NET, Classic ASP, JavaScript - Permalink

Chose file type:
<select onChange="window.location=this.options[this.selectedIndex].value;">
<option selected>Please select</option>
<option value="Music.aspx">Music Files</option>
<option value="Movie.aspx">Movies</option>
<option value="OfficeDoc.aspx#word">Word Files</option>
</select>

EXAMPLE:

Chose file type:

« Older Entries