Browse by Tags

Tagged Content List
  • Blog Post: Adding Stored Procs to your LightSwitch Intrinsic Database

    When you build a LightSwitch application the very first question you are asked is whether you want to connect to an existing data source or if you want to create a new one. If you choose to create new, this means that you want to build the data model using the LightSwitch data designer and have LightSwitch...
  • Blog Post: Working with SQL Server LocalDB in LightSwitch Projects in Visual Studio 2012

    Note: This article applies to LightSwitch in Visual Studio 2012 (LightSwitch V2) In Visual Studio LightSwitch , when you design your data model through the Data Designer you are either creating new tables or attaching to external data sources. When you create new tables, LightSwitch automatically...
  • Blog Post: How to Connect to and Diagram your SQL Express Database in Visual Studio LightSwitch

    Visual Studio LightSwitch makes it easy to create and model database tables using the Data Designer . With this designer you have a simple interface into the Tables, Columns and Relationships that make up your data model. When you create tables this way, under the covers LightSwitch creates a SQL Express...
  • Blog Post: Bootstrapper Package for SQL Server Express 2008 R2

    A couple weeks ago my good friend and MVP, Robin Shahan (RobinDotNet) , wrote up instructions on how to get a bootstrapper package for SQL Server Express 2008 R2 that you can use with ClickOnce deployments. Visual Studio 2010 comes with the bootstrapper for SQL Server Express 2008 but not R2. Robin’s...
  • Blog Post: Step-by-Step: Installing SQL Server Management Studio 2008 Express after Visual Studio 2010

    UPDATE 7/31/2012 - Since this post new versions of SQL Server & Visual Studio have been released. To install the latest version of SQL Server see SQL Server Install . For more information on working with SQL Server Local DB in Visual Studio 2012 see Working with SQL Server LocalDB in Visual Studio...
  • Blog Post: SQL Server 2008 Express How Do I videos

    Recently I’ve gotten a lot of questions about how to work with and connect to SQL Express data. ( SQL Express edition is the free version of SQL Server that comes with Visual Studio ). Well if you haven’t seen these videos on getting started with SQL Express you should check them out: SQL Server 2008...
  • Blog Post: Building Occasionally Connected Smart Clients with WPF

    This month Dev Pro Connections has an article by Milind Lele on using Sync Services in a WPF application: Building Occasionally Connected Smart Clients with WPF With Sync Services and Visual Studio 2008 you can visually design your local data cache and have it automatically synchronize your data with...
  • Blog Post: Inserting Master-Detail Data into a SQL-Server Compact Edition Database

    Yesterday John posted on the Visual Studio Data blog how to Refresh the Primary Key Identity Column during an Insert Operation using SQL Server. In that post he shows how the DataSet designer sets up a batch Insert statement to retrieve identity keys automatically. A while back I wrote about how to insert...
  • Blog Post: “Moving in” to Windows 7: My Favorite Features & Some Tips on Setup

    Last week I installed Windows 7 Enterprise on my main laptop – a Lenovo T60p ThinkPad. I was up in Redmond and MSIT made it available via a super-easy network boot that installs Office Enterprise, all the IT-required software like anti-virus, and all the drivers you need automatically. (I can’t say enough...
  • Blog Post: Attaching a Local SQL Server Database Using sqlcmd

    I've been getting asked a lot lately about how to easily attach a local SQL Server/Express database file (.MDF file) to an instance of SQL Server (any edition) . In most of my samples I distribute local SQL Server databases and use user instance connection strings so that if you are running Visual Studio...
  • Blog Post: Editing Data from Two Tables in a Single DataGridView

    I've had a lot of questions lately on how to display data from two separate tables in the database into a single DataGridView for editing. It sure would be nice if all our data was in a single table, but in reality most of the time it's not. Basically the problem is that we want one single table (entity...
  • Blog Post: Enabling Remote SQL Express 2008 Network Connections on Vista

    Today I spent way too long trying to enable remote network connections on my SQL 2008 Express database running on my Vista development machine so I thought I'd post the steps here. Please note that these settings may NOT be appropriate for your production environments. I'm a developer ;-), hence this...
  • Blog Post: What's New in Visual Studio 2008 SP1 - Client and Data Features

    Last night I spoke at East Bay.NET UG on some of the new features in Visual Studio Service Pack 1 focusing on client and data. I did a whirlwind tour of new SQL 2008 data types and Sync Services enhancements , ADO.NET Entity Framework , ADO.NET Data Services , WPF performance and data enhancements ,...
  • Blog Post: Channel 9 Interview: SQL 2008 & Occasionally Connected Client Support in Visual Studio SP1

    I just posted a new Channel 9 interview with Milind Lele, a PM on the VS Pro Tools team. In this interview Milind shows us the improvements made to the tooling in Visual Studio SP1 for occasionally connected clients as well as the new data type support for SQL Server 2008. Using SQL 2008 built-in...
  • Blog Post: Support for SQL 2008 Data Types Coming into LINQ to SQL

    Check it out, on the ADO.NET Team blog Faisal Mohamood, a PM on the LINQ to SQL team, posted on the new features you can expect to see added to LINQ to SQL. This includes support for new data types coming in SQL 2008. Enjoy!
  • Blog Post: Resizing Images Stored in SQL-Server

    In SQL-Server we can store images inside database tables directly using the Image column type. And with .NET 2.0 data binding it can automatically convert these images (stored as byte arrays) into System.Drawing.Image classes for you. For instance, say you have a table called Pictures that has a column...
  • Blog Post: Building a Secure Login Form (Parameterized Queries Part 2)

    In my first post on parameterized queries I built a simple login form that really was a contrived example meant to showcase how to use the TableAdapter Configuration Wizard to configure a parameterized query. However, since I opened myself up here, I felt it socially responsible to show how to make this...
  • Blog Post: Working with a Local Data File in VS

    Visual Studio 2005 made some big improvements in the way applications work with data, from BindingSources to the Data Sources Window all the way to a free version of SQL-Server called SQL-Server Express . I've had a few customers get stuck on using SQL-Server Express local database files with their project...
  • Blog Post: Reading from a Serial Port and Saving to a Database

    Recently I was sent a question about how to read from a serial port and save the information to a database so instead of following up privately I thought I'd post my answer here. There's a good article in the MSDN Library that has some hints on how to do this with the System.IO.Ports.SerialPort class...
  • Blog Post: Visual Basic How-To Video Series is Online

    This how-to video series is dedicated to getting Visual Basic developers productive on areas of data-based Windows Application development. The series starts with the basics of database development with SQL-Server 2005 Express then walks through the details of connecting to and querying databases, and...
  • Blog Post: SQL Server Express Video Series

    If you're new to SQL Express , Reporting Services , or databases in general, you'll want to check out the SQL Server Express video series up on www.asp.net . I just finished watching them myself. These videos walk you through all the free tools you get with SQL Server Express edition . They show how...
Page 1 of 1 (21 items)

Browse by Tags