Home » Posts tagged "Access" (Page 4)

Archive for the 'Access' Tag

Monthly Event Calendar – Control parameter query

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], […]

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, […]

Simple record query inside gridview

Here is simple record query inside the datagrid. I was looking for this solution which does not require code behind. Access DB structure Detail.aspx page code: <form id=“form1” runat=“server”> <div> <asp:GridView ID=”GridView1″ runat=”server” AutoGenerateColumns=”False” DataKeyNames=”ID” DataSourceID=”DetailView” GridLines=”None”> <Columns> <asp:TemplateField> <ItemTemplate> <table width=”660px” border=”0″ cellpadding=”0″ cellspacing=”0″> <tr> <td colspan=”4″> <a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”)%>&pic=p1″><img src=”images/<%# Container.DataItem(“Pic1″)%>” width=”75px” height=”54px” border=”0″/></a>&nbsp; […]