Browse by Tags
All Tags »
C# »
Data »
VB (
RSS)
OK, no more SSDT jokes! SSDT, or SQL Server Data Tools, give you the features of SQL Server Management Studio within Visual Studio 2012. You can use the SQL Server Object Explorer from the SSDT to create and maintain tables in your databases. See this...
No, SSDT is not a disease; it is a set of SQL Server Data Tools that are included as part of Visual Studio 2012. You can use the SQL Server Object Explorer from the SSDT to maintain or view your databases. See this link for an introduction to SQL Server...
If you use Visual Studio AND SQL Server Management Studio, you'll be glad to hear that the SQL Server Management Studio tools, called SQL Server Data Tools (SSDT), are now a part of Visual Studio 2012. You can create, edit, and delete SQL Server tables...
In this prior post , I introduced the new VS 2010 Database Project. Forget all of it. VS 2012 comes with a new Database Project! I have not yet worked with the new Visual Studio 2012 Database Project, but will write a post as soon as I do. For now, I...
The startup form is the first form that is launched when your application is executed. By default, a Windows Forms project creates a default form when the project is created. This form is set as the startup form. You can change the startup form to any...
If you want to retrieve one field from a table, you can use the ExecuteScalar method. This method executes a sql statement or stored procedure and returns a single value. Be sure to import the namespace: System.Data.SqlClient In C#: decimal amt; // Open...
The trick to obtaining the list of database names from SQL Server is to know the name of the system stored procedure that you need to call. This post presents a static/shared method for obtaining the names of the databases in a particular SQL Server instance...
There are some scenarios that require building a connection string at runtime. For example, if you are building a database utility or if your application allows working with multiple databases. In these cases, you may want to ask the user for the basic...
The new Visual Studio 2010 Database Project, as described in this prior post , makes it easy to work with scripts for an existing database or build new scripts directly within Visual Studio. This post details how to add stored procedure scripts to a Database...
The new Visual Studio 2010 Database Project, as described in this prior post , makes it easy to manage the scripts for your database from within Visual Studio. This includes building the schema scripts from the individual database object scripts and deploying...
The new Visual Studio 2010 Database Project, as described in this prior post , makes it easy to work with scripts for an existing database or build new scripts directly within Visual Studio. This post details how to add table scripts to a Database project...
The new Visual Studio 2010 Database Project, as described in this prior post , makes it easy to work with scripts for an existing database directly within Visual Studio. You can automatically build scripts for your existing tables, stored procedures,...
Visual Studio 2010 has a new Database Project. The scripts in this new Database project define your database just like the files in your code projects define your application. The prior Database project (the one under the "Other Projects" node...
Sometimes a tool comes along that is so demure yet so useful and easy to use, it is very hard to say good-bye. But our easy breezy Database project from Visual Studio 2003, Visual Studio 2005, and Visual Studio 2008 is now gone. It was replaced with a...
When I found out what box selection can do (as described in this earlier post ), my first thought was of stored procedures. Especially those update stored procedures with all of that typing! If you build your stored procedures in Visual Studio, you can...
There may be times you need to build a DataTable using code instead of retrieving the data from a database. This post provides the code for building a DataTable using VB or C# code. In C#: DataTable dt = new DataTable("Customers"); DataColumn...
Whether it be SQL Server, Access, Oracle, or mySql, most applications write to one kind of database. But what if your application requirements are such that you have to support multiple database types? Then the DbProviderFactory is for you. For example...
Despite the fact that there is a free version of SQL Server called SQL Server Express , there are still applications that require using a Microsoft Access database. But since these are dwindling in number, there are few articles or posts devoted to accessing...
Despite the fact that there is a free version of SQL Server called SQL Server Express , there are still applications that require using a Microsoft Access database. But since these are dwindling in number, there are few articles or posts devoted to accessing...
There may be times that you need to read fixed length files into your application. For example, you obtain output from a legacy system or other application in a fixed length text file format, and you need to read and use that data in your application...
More Posts
Next page »