data access

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

My experience with 3.5G mobile broadband

I've had 3.5G data access with a variety of data modems for almost a year now. I started off early last year with a PCMCIA Vodafone-branded modem. I have since used a USB Huawei-branded modem before finally migrating to a 3.5G PDA, which I run as a...

Tags: HSDPA, Mobile, Broadband, Operator, Data Access, Speed, PDAs, Cellular Phones, Handhelds, Hardware, Consumer Electronics, Personal Technology, Paul Mah

Blog posts 2008-01-22

Use the data access layer to simplify architecture

DAL generation toolI have written a .NET data access layer framework generation tool which uses a very similar methodology to tony's discussion above. It's very simple and gets to the point, takes only 2 mins to run. Feel free to try it and let me know what you think.http://www.codeauthor.org

Tags: big_knife@..., generation tool, data access

Discussion threads 2007-05-29

Performing a search of my DB in Access using data access pages

Hi all -I am trying to run a search of my DB through a query using a couple of fields as a front end wild card search. Ex. DB Field1: NAMEwild card entry1: FUNDB Field1: AGEwild card entry1: 23SEARCHI am creating a WHERE statement of [NAME %FUN% AND AGE...

Tags: Microsoft Access, aczocher@..., data access, wild card, card

Discussion threads 2007-03-26

Applied reflection: Write 80 percent less access code when interacting with a database

Databaseinteraction is old hat to enterprise application developers. If you are a .NET developer,chances are you have used the SqlParameter, SqlCommand, and SqlConnection classes. There is also a high probability thatyou have noticed how monotonous and time consuming it is to use these classesto implement data access. Microsoft solved some...

Tags: Â Â Â Â Â Â Â, data access, Data Access Block, database, Database interaction, SqlParameter, Zach Smith

Technical articles 2006-09-26

Build a data-bound grid with C# and ADO.NET

Data access is the basis of any application. In thisarticle, I will show you how to access SQL Server-based data using C# andADO.NET, as well as how to display the data in a data-bound grid control. I usea simple C# application as an example.ADO.NET architectureADO.NET allows you to work without...

Tags: C#, data access, data source, grid, Irina Medvinskaya, Microsoft ADO.NET, Microsoft SQL Server, namespace, server

Technical articles 2006-08-30

Return resources to the system to improve .NET performance

I prefer the usingIn C#, I prefer the using keyword, like this:using(SqlConnection conn = new SqlConnectionconns){conn.Open;}The scope defines the object lifetime, regardless of how it exits the scope (exception, etc) the dispose for the object is automatically called and Close is handled by the Dispose.Nice little blog that talks about...

Tags: developer, Data Access Application Block, resource, cleanup, csharp, rnshayes@..., programming, data access, Microsoft .NET, performance

Discussion threads 2006-08-16

Learning to Control Data Access

Things just continue to change. Actually, IT is always changing and always will. That is part of the fascination and draw for me, and one of the mainreasons I chose this field. Right now,youÂ're probably wishing I would pick a topic and run with it; and so Iwill....

Tags: audit, Control Data, data access, donÂ't, user access

Blog posts 2006-07-17

Shorten development time by using parameterized queries in ADO.NET

Forsome time now stored procedures have been the preferred method of data accessfor enterprise application development. Stored procedures offer bettersecurity, better encapsulation, and can implement complex logic withoutcluttering up application code. However, they also come with disadvantages:Developershave a tendency to put business logic inside stored proceduresYoumust change development environments to...

Tags: data access, Microsoft ADO.NET, Zach Smith

Technical articles 2006-07-12

Use the data access layer to simplify architecture

The data access layer provides a way to design an application with a clean separation of code into their functional areas within an application. Learn more about building your own data access layer. Unless you are working with legacy code or systems, most application development is done in...

Tags: Storage, Databases, Tony Patton, industry trend, data access, database, data access code, .NET Newsletter, Method, Application, Procedure, Class, GetCustomers Method, AddCustomer Method, DeleteCustomer Method, RunProcedure Method, GetDataReader Method, WriteToEventLog Method, Hardware, Enterprise Software, Software, Data Management

Technical articles 2006-05-30

Use the data access layer to simplify architecture

Unless you are working with legacy code or systems, mostapplication development is done in a multiple tier or layered environment. Thismay include a database layer along with the business rules and presentationlayers. A key part of every n-tiered environment is the database tier. In thiscolumn, we examine how the database...

Tags: data access, data access code, database, Tony Patton

Technical articles 2006-05-30

Integrate Microsoft Excel and Access with VBA to create sophisticated applications

Extracting data and moving it between Microsoft Excel and Access can usually be accomplished in several different ways. However, there are situations where Visual Basic for Applications VBA is not only the best way to retrieve data, it is the only way. This downloadable chapter excerpt from Integrating Excel and...

Tags: data access, Integrating Excel, Michael Schmalz, Microsoft Access, Microsoft Corp., Microsoft Excel, Microsoft Visual Basic, O'Reilly Media Inc., TechRepublic Inc., VBA, Web, Web site

Download resources 2006-02-24

Data Access

What is the best way to show a list of tables from an access database possibly a datagrid then be able to click on the individual table to call its data up to be able to edit / delete the info using vb.net?I don't work in vb, I use Delphi...

Tags: Programming languages, Databases

Q&A 2005-11-28

Get a jumpstart on the inevitable migration from VB6 to Visual Basic 2005

Like it or not, Microsoft has decided to phase out its support of the Visual Basic 6 development platform. It seems inevitable that die hard users of VB6 will be migrating to new platforms. Visual Basic 2005 seems to be a logical choice since it borrows heavily from its predecessors....

Tags: data access, database, free download, Microsoft Corp., Microsoft Visual Basic, Microsoft Visual Basic 6.0, Microsoft Visual Studio, Microsoft Visual Studio 2005, migration, O'Reilly Media Inc., SQL, Visual Basic 2005, Web, Web service, Web site, Windows application

Download resources 2005-10-11

Create a form-type Data Access page in Access

It would be useful if your mobile users could view and edit data from their Access database anywhere, anytime from their mobile devices. Learn how to do just that by creating a form-type Data Access page that can be made accessible to your users over the Internet. Help users...

Tags: Microsoft Access, Databases, Microsoft Office, Mary Ann Richardson, Data Access Page, data access, form-type Data Access page, database, Microsoft Office Suite Access Tips Newsletter, Data Page, Enterprise Software, Software, Data Management, Office Suites

Technical articles 2005-04-12

Data Access Pages - URL Params

I'm tring to find an easy-to-implement front end for a networked database. I'm experimenting with Data Access Pages, since it'll be easy to tie in to our existing web-based portal. However, one thing that would make this a done deal would be the ability to pass URL parameters to the...

Tags: Data Access, Data Access Page, Data Access Pages, database, jbeckmeyer, Microsoft Access, PHP, simiasato, software

Discussion threads 2005-02-07

MS Access data access pages

I have created a data access page using the wizard in Access 2000. The page works on my local machine fine. I upload the page to the web server and when I try to run it, I get the message "Data provider could not be initialized" then I...

Tags: Data Access, Data Access Page, Data Access Pages, Microsoft Access, Microsoft ASP, Microsoft Corp., scott.vrana@..., software

Discussion threads 2005-01-24

Data Access Pages in ACCESS

I'm trying to create Data Access Pages DAP for users to access an Access database via Internet Explorer. In order to do this, XP Office Web Components are needed.Do these web components need to be installed on each client or only at the shared web server where the database...

Tags: Data Access, Data Access Page, Data Access Pages, El Guapo, Microsoft Access, OWC, server, software

Discussion threads 2004-11-10

Tactical data access and analysis should be your business information design drivers

A first business information BI data warehouse implementation often can be characterized as a utilitarian effort, subordinate to the company's core database systems. User perception and the mindset of non-IT management, in particular, may cast BI and its attendant data marts, analytics, and other innovations as simple conveniences. This is...

Tags: Business intelligence, Storage, Databases, data access, Scott Robinson, analysis, data warehouse, data warehouse environment, database

Technical articles 2004-02-06

Software Design: Using data source architectural patterns in your .NET applications

At the heart of every business application is data access. As a result, developers and architects spend much of their time designing, evaluating, testing, and fretting over the data access techniques used in their applications. Since this area of application design has been so well trodden it is no surprise...

Tags: Microsoft .NET, software, Daniel L. Fox, data access, data source

Technical articles 2003-12-11

Web services B2B implementation demonstration: John's business logic

In part three of this series, we reviewed the design principles behind database modeling and implemented some common practices to create the physical database structures for both John's and Tom's applications. We also generated our data access tier and created database entrance points for each entity in our database by...

Tags: Kevin Koch, data access, Web services B2B, implementation demonstration, Web Services B2B Implementation Demonstration, Web, database, business logic

Technical articles 2003-10-08