The code is initial designed by Mircho Mirev [ momche.net ]. I’ve enhanced this script so instead of array of static data the text-box auto-complete uses database back end. Default.asp <%@LANGUAGE=”VBSCRIPT” CODEPAGE=”65001″%> <!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN” “http://www.w3.org/TR/html4/loose.dtd”> <html> <head> <meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″> <title>Intellisense Example</title> <SCRIPT language=”JavaScript” src=”moautocomplete.js”></SCRIPT> </head> <body style=”font-family: Verdana, […]
Home » 2011 (Page 12)
Archive for 2011
One click gridview record update
Here is how you can update record in a gridview with just a one click. Code: <asp:TemplateField HeaderText=”Active”> <ItemTemplate> <asp:CheckBox ID=”ActiveCheckBox” runat=”server” Checked='<%# Bind(“Active”) %>’ /> <asp:LinkButton ID=”UpdateButton” runat=”server” CausesValidation=”True” CommandName=”Update” Text=”Update” /> </ItemTemplate> <HeaderStyle CssClass=”datagrid-th” /> </asp:TemplateField> Access Data Source <asp:AccessDataSource ID=”RepoMgt” runat=”server” DataFile=”/my_folder/mydb.mdb” DeleteCommand=”DELETE FROM [MyCars] WHERE [ID] = ?” InsertCommand=”INSERT INTO [MyCars] […]
Microsoft SQL Express Version
To check MSSQL Version and service pack, create new query, pass below parameters and run the query. select serverproperty(‘ProductVersion’) Version, serverproperty(‘Edition’) Edition, serverproperty(‘ProductLevel’) ProductLevel, serverproperty(‘ComputerNamePhysicalNetBIOS’) PhysicalNetBIOS, serverproperty(‘ResourceVersion’) ResourceVersion