Description: ASP.NET Toolbox calendar control which use control parameter to query db records and display event(s) on calander item selection change. This is suitable for deisplaying events on PostBack call on the same page. Elements: Events.mdb / or MS SQL Web.config Month-2.aspx Month-2.aspx.vb Dtgrid.css Method: Create table Events (Id [primary key – AutoNumber], Event [Text], […]
Archive for the 'Access' Category
Text-box autocomplete
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, […]
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] […]