Product Features
MUST product and services
Library Overview
Technical Support Library
Upsizing and SQL
Upsizing technical papers
.net Conversions
.net technical papers
Access Technical
Access technical papers
Quick Start Guide
upsize quickly
using schemas and security
auditing
translating SQL
commissioning
from Access to Excel reporting
Resolve SQL translation issues
Working with vw_tblParameters
Access Form to WebForm methodology
Upsizing Forum
Videos
MUST Videos
MUST+SQL Videos
MUST+WEB Videos
Highlights
Security
Data structures
Layout and design techniques
VBA to VB.NET code conversion
Articles and publications explaining various .net design issues when upsizing
Security
Integrating ASP.NET security with SQL Server security using LINQ
If you have an internet application where you are not going to use windows authentication, ASP.NET security provides an excellent security model to use which includes security controls and a membership database. This article illustrates how to provide further intergration with SQL Server security, mapping asp.net users and security roles to SQL Server users and security roles. In addition, we show how with LINQ we can wrap a DataContext class building user specific connection strings at runtime.
Data structures
Getting started with LINQ
This articles provides a step-by-step guide to creating an LINQ Model, and discusses how models are updated.
Getting started with the Entity Data Model
This articles provides a step-by-step guide to creating an Entity Data Model, and discusses how models are updated and re-generated.
Working with foreign keys in tables and views in the Entity Data Model
This articles illustrates how to reference a foreign key when working with a table in the EDM, it also shows how to avoid the referencing issue through the use of views.
Choosing a SQLDataSource, LINQDataSource or EntityDataSource
This article is aimed at helping you understand the differences between choosing a SQLDataSource, LINQDataSource or EntityDataSource and summarises the advantages and disadvantages of each data source type.
Formatting date and currency data in ASP.net
This article shows you how to gain better control over the formatting of date and currency data in templates when using GridView, FormView, ListView or DetailsView controls. It also describes how to avoid problems when formatting data for editing or inserting new rows.
.net data challenges, drop-down lists and SET NULL on relationships
Dropdown lists in .net can fail when data in the underlying fields is not available in the drop down list, why does this happen ? and how can we resolve the problem ? If you have ever seen the error 'has a selected value which is invalid because it does not exist in the list of items' then read this article to learn how to resolve these issues.
.net data challenges, data binding
Dropdown lists when you want to have no choice made, problems with field names, optimistic concurrency, get to grips with data binding in this article
Layout and design techniques
CSS Design Strategy
CSS can be used to simplify editing control poisition and width in webforms; avoiding the need to make changes in several layout templates. This article presents a strategy for using CSS to simplify adjusting FormView layouts which use absolute positioning for controls.
Altering a webform layout with absolute control positioning in VWD 2008
Once Access Forms have been converted to WebForms minor adjustments to the alignment of controls may be required. This article shows how to align multiple controls when using a FormView control with absolute positioning of the controls.
Enabling Ajax in WebForms
Enabling Ajax in your WebForms reduces screen flicker, improves performance and creates a better experience for your users, this article discusses how to add this to your web site.
VBA to VB.NET code conversion
Converting Access VBA to VB.NET – Global Variables
In this article we look at how to translate Access Global Variables into equivalent variables in a .net web form application, we also show how to construct a support class enabling converted Access VBA code to run in a web form application.
Converting Access VBA to VB.NET – General Prinicipals
This article discusses general issues relating to converting the VBA Code in an Access application to code that can form part of your WebForm application in .net. We know that it is possible to convert VBA to VB.NET, but there are a number of issues which you need to consider that will affect the degree of success in doing this.
Copyright © 2009 ASC Associates,
Technical Support
support@ascassociates.biz
,
Sales Enquiries
sales@ascassociates.biz