Home ›
All Tags » sql » Access (RSS)

Browse by Tags

Related Posts

  • Cant get a data

    Hi, all Not much to explain I write this code and I dont get data (if I run the query in the DB it works) 1 private void ShowFullView(String strFullViewName) 2 { 3 OleDbCommand command = new OleDbCommand( "SELECT sCat_Code " + 4 "FROM CATEGORIES_TAB " + 5 "WHERE sName = '...
    Posted to Access Databases and AccessDataSource Control (Forum) by SweeT EviL on 04-10-2009, 12:00 AM
    Filed under: sql, sql queries, sql Statements, access, Access Database, Access db, asp.net, c#, connection string, ConnectionString, data access, DataAdapter

  • Dazed & Confused, from VB6 to V_Web

    I have a simple VB6 project that I was enhancing when I became concerned with the diminishing on-line support for old-VB and the hugely growing body of support for VB 2008 and V Web Dvlpr. Essentially, my project enables a user to select one of 10,000 records in an Access table, then I massage the fields...
    Posted to Getting Started (Forum) by TooNew on 09-21-2008, 12:00 AM
    Filed under: Access, SQL

  • Google Maps via ASP.NET / SQL Server Tutorial

    Hi, I worked out for google map with ASP.Net / VB.Net. below steps you have to follow, 1. You need to get encrpyted key from google which key for your own website. 2. create a table as below, if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[map]') and OBJECTPROPERTY(id, N'IsUserTable'...
    Posted to Tips & Tricks (Forum) by antonyvijayan on 07-08-2008, 12:00 AM
    Filed under: SQL, User control, .net, .NET Answers, .NET applet, .Net Faqs, .net interview faqs, .NET Interview Question, Abstract class, Access, ADO.Net, Ajax xml-script Tabstrip, asp, Asp .net, asp.NET 1.1, asp.NET 2.0, ASP.NET AJAX, ASP.NET TextBox Javascript MultiLine MaxLength, aspose.newsletter, c#, class, Code sample, Code sample sql script countries country province Provinces server 2000, code snippets, daily Free Code, Database, email, FAQ, .net layered design, asp .net ... c# ... SQL, structure, .Net FAQ Links, ASP.NET

  • Inserting into two tables at the same time with the same ID

    Hi, I am not sure if this is the right place to ask this but I have been searching the web and have yet to come across a suitable example. I am new to .NET but have had previous experience with ASP Anyway here goes, I have two tables in an Access database, named Colours and Horse, Horse (ID(AutoNumber...
    Posted to Access Databases and AccessDataSource Control (Forum) by richardh09 on 05-30-2008, 12:00 AM
    Filed under: Primary Key, record, Scope Identity, sql, SQL Query, vb.net, access, Access database query string, access oledb, asp.net, ASP.NET 2.0, data access, database, Insert into Access Database, insert method, SELECT command, .aspx.vb, .Net 2.0, Access Database

  • create table problem

    can anyone tell me what's wrong with this code: CREATE TABLE tbl (id INT , name VARCHAR (50), isAdmin YESNO, age INT , comments MEMO, PRIMARY KEY (id)); everytime i'm building the application it gives me error in syntax... i've tried this in ms access and it works just fine...
    Posted to Access Databases and AccessDataSource Control (Forum) by chryslergirl on 12-18-2007, 12:00 AM
    Filed under: sql, access, ms access, create table

  • Performance tips for Database access

    1.Use Stored Procedures whenever possible stored procedures are highly optimized tools that result in excellent performance when used effectively. 2.Use the Optimal Managed Provider Make the correct choice of managed provider, rather than relying on a generic accessor. 3. Pick Data Reader over Data Set...
    Posted to Tips & Tricks (Forum) by swap on 02-09-2007, 12:00 AM
    Filed under: SQL, Access, ADO.Net, Database, Performance

  • Is it true that Access VBA function calls don't work in ASP.NET?

    I have an Access database and a VBA function in a module. I need that function for my query to work but when I call the query from ASP.NET, it won't work. I get an error "function not defined". I browsed through the net and I found out this doesn't work in ASP.NET. Is it true and if...
    Posted to Access Databases and AccessDataSource Control (Forum) by calinetfan on 07-07-2009, 12:00 AM
    Filed under: SQL, Access, vba

  • asp:dropdownlist accessdatasource INSERT and UPDATE commands

    Ok, this is documented all over the internet but I can't find what I'm looking for. I have a detailsview with a ddl. I need to take the value and enter it with both update and insert commands. This is my ddl <asp:DropDownList runat="server" ID="ddlRole" DataSourceID="adsUser"...
    Posted to Data Presentation Controls (Forum) by Drackie on 08-07-2009, 12:00 AM
    Filed under: DropDownList, sql, VB, access

  • data type mismatch

    Hey, I'm stuck with this code as it is throwing a data type mismatch. Can anyone see the error? I've spent a long time on this and can't see it! Please excuse the classic asp! I'm just learning how to use the oledbdatareader at the moment and haven't re-written All with ID in the...
    Posted to Access Databases and AccessDataSource Control (Forum) by Drackie on 08-10-2009, 12:00 AM
    Filed under: access, sql, type mismatch

  • DetailsView will not update!

    I give up with this one, can anyone tell me why this won't update? I have spent hours on this. If I don't use parameters in the datasource then it jumbles everything up but if I do, it won't update at all! I can see the values, i can play with them and see that they are correct but they do...
    Posted to Data Presentation Controls (Forum) by Drackie on 08-11-2009, 12:00 AM
    Filed under: DetailsView, DropDownList, sql, access
Page 1 of 2 (15 items) 1 2 Next >

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2010 Microsoft Corporation.