Browse by Tags
All Tags »
SQL Server (
RSS)
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 »