Browse by Tags

All Tags » VB » Data » C# (RSS)
The Transact-SQL Editor option in Visual Studio 2012 allows you to query your database directly from Visual Studio. It is part of the SQL Server Data Tools (SSDT) provided in Visual Studio. See this prior post for more information on SSDT. With the Transact...
with no comments
Filed under: , , , , , ,
Visual Studio 2012 introduced a new SQL Server Database Project. This post first covers what happens when you publish a Database Project. It then details how to publish your Database Project. See this link for an introduction to the Visual Studio 2012...
When you work with a SQL Server Database Project in Visual Studio 2012, two terms you will come across are " Data-tier application " or DAC, and " Data-tier application package " or DACPAC. Data-tier application (DAC) A data-tier application...
Visual Studio 2012 introduced a new SQL Server Database Project. This post details how to create a new table script in your Database Project. See this link for an introduction to the Visual Studio 2012 SQL Server Database Project. To create a new table...
Visual Studio 2012 introduced yet another new database project. This new database project not only manages your scripts, it also provides GREAT features for deploying your database changes. In my prior posts on the SQL Server Data Tools (SSDT), I focused...
Visual Studio 2012 introduced a new database project. This post details how to create one of these new database projects from an existing database. See this link for an introduction to the SQL Server Database Project. To create a new database project...
As detailed in this prior post , you can execute SQL Server stored procedures using the SQL Server Object Explorer that is part of the SQL Server Data Tools (SSDT). But in that example, the stored procedure had no parameters. This post goes one step further...
As part of your development or debugging process, you may need to execute a stored procedure from your development database. That's easy to do using the SQL Server Object Explorer that is part of the SQL Server Data Tools (SSDT) in Visual Studio 2012...
When developing an application, it is often useful to have test data in the tables of your development database. You can then try out your stored procedures or write automated code tests using your sample data. With the SQL Server Object Explorer that...
The SQL Server Object Explorer in Visual Studio 2012 is part of the SQL Server Data Tools (SSDT). You can use the SQL Server Object Explorer to design your database, tables, stored procedures, and other SQL Server objects. This post focuses on creating...
We all use some type of data in our applications: configuration information, game scores, map coordinates, shopping cart details, or line of business information. All of that data needs to be stored somewhere and readily retrieved. If that “somewhere...
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...
with no comments
Filed under: , , ,
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...
2 comment(s)
Filed under: , , , , ,
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...
1 comment(s)
Filed under: , , , ,
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...
7 comment(s)
Filed under: , , , ,
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...
6 comment(s)
Filed under: , , , ,
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...
More Posts Next page »