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 'MS SQL' Category
Form Drop-down-list binding
Learn how to make easy drop-down-list with a list of different choices and binding the existing data with the form. Screenshot speaks for itself.
ASP.NET Login Page with SQL Backend
Let’s start simple by creating form controls: <table> <tr><td>Usernname</td><td><asp:TextBox ID=”user” runat=”server”></asp:TextBox></td></tr> <tr><td>Password</td><td><asp:TextBox ID=”password” runat=”server” TextMode=”Password”></asp:TextBox></td></tr> <tr><td></td><td><asp:Button ID=”Button1″ OnClick=”submit” Text=”Login” runat=”server” causesValidation=”true” /></td></tr> </table> Now add some form validation: <table> <tr><td>Usernname</td><td><asp:TextBox ID=”user” runat=”server”></asp:TextBox> <asp:RequiredFieldValidator ID=”RequiredFieldValidator1″ runat=”server” ControlToValidate=”user” ValidationGroup=”UserCheck” ErrorMessage=” <font color=’red’> « Username is required!</font> “> </asp:RequiredFieldValidator> </td></tr> <tr><td>Password</td><td><asp:TextBox ID=”password” runat=”server” TextMode=”Password”></asp:TextBox> <asp:RequiredFieldValidator ID=”RequiredFieldValidator2″ runat=”server” ControlToValidate=”password” […]