Nannette Thacker ShiningStar.net

ASP.net Technologies.

Browse by Tags

All Tags » SQL Server » ASP.NET (RSS)
C# and VB Project: A Tutorial Using Data Sets, Table Adapters, WebForms, Controls, File Upload, Excel Import
In this tutorial by Nannette Thacker, we will create a VB or C# project from scratch. We will create DataSets, TableAdapters, a WebForm and Controls, a File Upload, and import and view an Excel Spreadsheet, and more! We'll also learn about intellisense...
Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Importing the Excel Spreadsheet
By Nannette Thacker In the final installment of this tutorial, we look at importing the uploaded Excel spreadsheet into the application database tables using the DAL. The article series hosted on 4guysfromrolla.com continues with Importing an Excel Spreadsheet...
Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Creating a Data Access Layer (DAL)
By Nannette Thacker In the fourth installment of this tutorial, we create the Data Access Layer (DAL) used to communicate with the application database during the import process. The article series hosted on 4guysfromrolla.com continues with Importing...
Custom MembershipProvider ConnectionStringName Usage
By Nannette Thacker This is an issue that seems to confuse a lot of new developers. How do you use the "connectionStringName" defined within the membership provider area of the web.config file within a custom membership provider? Big mouthful, eh? Okay...
Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters
By Nannette Thacker In this tutorial, learn how to import data from an Excel Spreadsheet to a Database by creating a tiered application architecture using Visual Studio's Typed DataSets and TableAdapters. The application consists of an ASP.NET page that...
Creating a Database Connection to a Remote SQL Server Database within Visual Web Developer
By Nannette Thacker Step-by-step instructions for creating a database connection to a remote SQL Server Database, using Visual Web Developer. Go to the View menu item and select Database Explorer. Depending on how you have your Visual Web Developer interface...
Retrieving Values from a DataReader
By Nannette Thacker There are several ways to retrieve values from a DataReader. The first method is by using the index and looping through the fields in order as retrieved within the Select statement. Starting with the 0 index, you may use the GetValue...
More Posts