Browse by Tags

Home ›

All Tags » query » access (RSS)

SQL Having with parameters

I have an Access database and AccessDataSource control with the folowing code: < asp : AccessDataSource ID ="Broj_uzoraka_mjesecno" runat ="server" DataFile ="~/App_Data/Lab4_nov.mdb" SelectCommand ="SELECT Count([Analiza 1].[Uzorak ID]) AS [CountOfUzorak ID1], First...

Posted to Access Databases and AccessDataSource Control (Forum) by alensp on 09-03-2008, 12:00 AM
Filed under: query, SQL Query, access, accessdatabase, AccessDataSource SQL, ASP, ASP.NET 2.0, Insert into Access Database, Insert into SQL, ASP.NET Version:2.0.50727.1433, SELECT command, .ASPX, ConnectionString, No value given for one or more required parameters Repeater
Query Access database for DATE (using the > operator)

I am connecting to an access database in a .net page (using c#) I need to query the database for results matching a date that is greater than today. (I am using the results to populate a calendar control) something like: DateTime dtCurrentDate = DateTime.Today; strQuery = "SELECT * FROM myTable...

Posted to Access Databases and AccessDataSource Control (Forum) by wizzkidd07 on 06-14-2008, 12:00 AM
Filed under: query, access, database, datediff, dates
SQL Query issue with AccessDatasource

Ok, let me start by saying I can't do complex SQL queries :P I am using Access to generate my queries! Here is what I am stuck with: I have 6 tables which need joining, I'll only list the keys to be linked within the tables so as to simplify (I can do the other bit!) Incident UserID CartridgeID...

Posted to Access Databases and AccessDataSource Control (Forum) by Drackie on 08-13-2009, 12:00 AM
Filed under: access, sql, query
Gridview filtering - multiple filters

Hey, I'm stuck trying to get my gridview working with more than one drop-down filter. There is another post here with the same issue but I can't see the difference in code, it is probably something simple/easy. Here is my code: <%@ Page Language="VB" MasterPageFile="masterpage...

Posted to Data Presentation Controls (Forum) by Drackie on 08-14-2009, 12:00 AM
Filed under: GridView, DropDownList, sql, access, Query, filter
SQL query: Inserting multiple results into a new table

I have a MS ACCESS 2000 sql query that returns several results, sometimes up to 30 or so. I want to insert these results into a new table all at once, each with their own unique ID [once in the new table]. How is this accomplished? Thanks! Loren

Posted to Access Databases and AccessDataSource Control (Forum) by lorengphd1 on 11-13-2009, 12:00 AM
Filed under: SQL, query, Access