– Login to your server MS SQL Management Studio Express – Expand the database; expand the tables folder, right click on the table “[your table name]”, click “Open Table.” Make sure the primary key column(s) have been declared to not contain NULL values (when the table was first created). With the open table click on […]
Home » Posts tagged "Access" (Page 3)
Archive for the 'Access' Tag
Classic asp delete script
<% ‘define variables DIM objConn, objRS ‘connection DIM i_last, count, bgcolor ‘even row bg color Dim job, recID ‘fetching query strings job = Request.QueryString(“do”) recID = Request.QueryString(“rid”) Dim sqlstatement ‘ sql query command string If job = “del” Then SET objConn = Server.CreateObject(“ADODB.Connection”) objConn.ConnectionTimeOut = 30 objConn.Open “DSN=MySystemDSN” sqlstatement = “DELETE FROM Customers WHERE ID=” […]
Monthly Event Calendar – Query String Parameter
Description: ASP.NET Toolbox calendar control which use control parameter to query db records and display event(s) on calendar item selection change. This is suitable for displaying 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], […]