Nannette Thacker ShiningStar.net

ASP.net Web Application Development

Sponsors

News

See all Blog Posts by Nannette.

Nannette Thacker, consultant and owner of Shining Star Services LLC, specializes in development of custom dynamic database driven web applications utilizing ASP.net technologies. Nannette has been developing ASP sites since 1997. Nannette has written numerous articles on web development techniques and tutorials.

Nannette is the owner and developer of ChristianSinglesDating.com.

 Subscribe in a reader




Browse by Tags

All Tags » SQL Server (RSS)
Filtering Parameters in a SQL 2008 Stored Procedure
Ash explains the concept of Filtering Parameters in a Stored Procedure in this blog post. This method is safer and more beneficial than dynamically creating and passing a sql query from the code layer and using sp_executesql, as it helps to avoid sql...
SQL Server 2008 Web Edition and Express Edition Errors Resolved
Since I had purchased the SQL Server 2008 Web Edition for my database server, I decided to also install it on my development box. But when I tried to install the Management Tools, it errored with: "Previous release of Microsoft Visual Studio 2008." I...
SQL Server: Copying a Database, including Constraints, Keys, Indexes...
In SQL Server, if you wish to copy the structure of an entire database, including the Constraints, Keys, Indexes, etc., don't use the Import option, as it does not include the constraints, keys, indexes, etc. Instead, within SQL Server Management Studio...
Posted: Dec 01 2008, 10:26 AM by nannette | with 3 comment(s)
Filed under:
SQL Server 2008 Web Edition
SQL Server 2008 Web Edition I just purchased SQL Server 2008 Web Edition, and yes, it does exist and yes it is specifically licensed for those using it for web sites on a database server. The reason I say that is that we talked to 3 Microsoft employees...
Visual Studio 2008 does not support SQL Server 2008 - SP1 Needed
I just purchased Visual Studio 2008 and SQL Server 2008 Web Edition and after setting up the database server, I tried to add a connection to my Visual studio 2008 project to obtain a remote connection and was given this error message: "This server version...
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...
More Posts Next page »