Browse Blog Posts by Tags

All Tags » C# » Data (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Adding Tables with SSDT

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 link for an introduction to SQL Server Object Explorer...

Posted to Deborah's Developer MindScape by Deborah Kurata on Mon, Oct 22 2012
Filed under: Filed under: VB, C#, Visual Studio, .NET, CSharp, Data
Adding a New Database with SSDT

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 Object Explorer. To create a new database: 1) Open...

Posted to Deborah's Developer MindScape by Deborah Kurata on Sun, Oct 21 2012
Filed under: Filed under: VB, C#, Visual Studio, .NET, CSharp, Data
SQL Server Object Explorer in VS 2012

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 and stored procedures, you can write and execute...

Posted to Deborah's Developer MindScape by Deborah Kurata on Sun, Oct 21 2012
Filed under: Filed under: VB, C#, Visual Studio, .NET, CSharp, Data
Goodbye VS 2010 Database Project, We Hardly Knew Ye

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 wanted to provide your choices if you want your solution...

Posted to Deborah's Developer MindScape by Deborah Kurata on Sun, Aug 26 2012
Filed under: Filed under: VB, C#, Visual Studio, Data
Setting a Form as a Startup Form with Visual Studio

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 form within your application following the steps...

Posted to Deborah's Developer MindScape by Deborah Kurata on Wed, Dec 15 2010
Filed under: Filed under: VB, C#, .NET, CSharp, Data, WinForms
DAL: ExecuteScalar

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 connection using (SqlConnection cnn = new SqlConnection...

Posted to Deborah's Developer MindScape by Deborah Kurata on Sat, Sep 25 2010
Filed under: Filed under: VB, C#, .NET, CSharp, Data
Build a List of SQL Server Database Names

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. In C#: public static List<string> GetDatabaseNames...

Posted to Deborah's Developer MindScape by Deborah Kurata on Thu, Jun 3 2010
Filed under: Filed under: VB, C#, .NET, CSharp, Data
Building a Connection String at Runtime

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 parts of the connection and not require entry of...

Posted to Deborah's Developer MindScape by Deborah Kurata on Fri, May 28 2010
Filed under: Filed under: VB, C#, .NET, CSharp, Data
VS 2010 Database Project: Adding Stored Procedures

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 project Start by adding a VS 2010 Database...

Posted to Deborah's Developer MindScape by Deborah Kurata on Mon, May 3 2010
Filed under: Filed under: VB, C#, Visual Studio, .NET, CSharp, Data
VS 2010 Database Project: Building and Deployment

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 scripts back to the database. One of...

Posted to Deborah's Developer MindScape by Deborah Kurata on Mon, May 3 2010
Filed under: Filed under: VB, C#, Visual Studio, .NET, CSharp, Data
VS 2010 Database Project: Adding Tables

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 Start by adding a VS 2010 Database project to...

Posted to Deborah's Developer MindScape by Deborah Kurata on Mon, May 3 2010
Filed under: Filed under: VB, C#, Visual Studio, .NET, CSharp, Data
VS 2010 Database Project: Using an Existing Database

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, indexes, constraints, and so on. You can then check...

Posted to Deborah's Developer MindScape by Deborah Kurata on Sun, May 2 2010
Filed under: Filed under: VB, C#, Visual Studio, .NET, CSharp, Data
VS 2010 Database Project: An Introduction

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 in VS 2003/2005/2008 as detailed in this prior...

Posted to Deborah's Developer MindScape by Deborah Kurata on Sun, May 2 2010
Filed under: Filed under: VB, C#, Visual Studio, .NET, CSharp, Data
Requiem to the VS 2003/2005/2008 Database Project

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 new young tool that is more full-featured, more complex...

Posted to Deborah's Developer MindScape by Deborah Kurata on Tue, Apr 20 2010
Filed under: Filed under: VB, C#, .NET, CSharp, Data
Box Selection and Stored Procedures

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 save lots of typing time by leveraging the box selection...

Posted to Deborah's Developer MindScape by Deborah Kurata on Sun, Apr 4 2010
Filed under: Filed under: VB, C#, Visual Studio, .NET, CSharp, Data
Build a DataTable in Code

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 dc; dc = new DataColumn(); dc.DataType = typeof...

Posted to Deborah's Developer MindScape by Deborah Kurata on Sat, Feb 27 2010
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataTable
DAL: Using a Data Provider Factory

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, say you are building a product to sell to HR departments...

Posted to Deborah's Developer MindScape by Deborah Kurata on Fri, Sep 25 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataTable
Update a Microsoft Access Database

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 Access. This post (and my prior post that...

Posted to Deborah's Developer MindScape by Deborah Kurata on Tue, Aug 25 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataTable
Retrieve a DataTable using Microsoft Access

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 Access. This post (and my next post that demonstrates...

Posted to Deborah's Developer MindScape by Deborah Kurata on Tue, Aug 25 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataTable
Reading Fixed Length Files

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. NOTE: For more information on fixed length files...

Posted to Deborah's Developer MindScape by Deborah Kurata on Tue, Aug 25 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataTable, text file

Page 1 of 2 (31 items) 1 2 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.