Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Whidbey Q & A   (RSS)
Wednesday, August 09, 2006 3:10 AM

How to retrieve stored procedure return values from TableAdapter

If you’ve been wondering why you are not able to access stored procedure return values from TableAdapter, here’s the solution for you. I will use tbTasks table and spInsertTask stored procedure to demonstrate the solution. You can see definitions for
Posted by youngjoo | 18 Comments
Filed under:
Monday, April 10, 2006 3:57 AM

Q&A About SQL Server Everywhere

Steve posted some answers to many of the questions about SQL Server Everywhere... http://blogs.msdn.com/stevelasker/
Posted by SmartClientData | 2 Comments
Tuesday, February 21, 2006 6:06 PM

Splitting Typed DataSets from TableAdapters - Sharing Validation Code across the tiers

Article explaining how to separate TableAdapters from Typed DataSets to leverage common validation routines between the client and reinforced by the server.
Posted by Steve.Lasker | 17 Comments
Filed under: ,
Wednesday, November 23, 2005 5:03 PM

Embedding SQL Server Express into Custom Applications

Rob Walters, from the SQL Team, and I worked on an article for working with SQL Express in Windows Forms applications. There are a couple of quirks when it comes to Click Once that have been included in this MSDN article. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/EmSQLExCustApp.asp
Posted by SmartClientData | 2 Comments
Saturday, November 19, 2005 2:40 AM

How do I get to the generated code?

In order to get to the code that is auto-generated by Visual Studio, follow these steps: 1. In the menu, select View -> Solution Explorer 2. In Solution Explorer, click the “Show all Files” icon at the top 3. Expand the file (e.g. Dataset1.xsd) that
Posted by SmartClientData | 1 Comments
Filed under:
Friday, November 18, 2005 9:30 PM

Data Sources window is inactive in Design View

On certain machines, after installing Visual Studio 2005, the contents of the Data Sources window disappears when a design surface that allows drag and drop from the Data Sources window is active. For example, the Windows Forms designer, User Control
Posted by SmartClientData | 14 Comments
Filed under:
Friday, August 26, 2005 9:24 PM

Working with local databases

Overview In Visual Studio 2005 we added a number of features to help developers build and deploy applications that need a local data store. Here's a quick peek at how it works. In order to work with a local database file, you can simply add the file to
Posted by SmartClientData | 49 Comments
Filed under: ,
Wednesday, August 24, 2005 3:26 PM

Drag Once w/Custom Controls

Article written for CoDe magazine describing how to customize the controls listed in the Data Sources Window for Drag Once Databinding http://www.code-magazine.com/Article.aspx?quickid=0411071 Steve
Posted by SmartClientData | 2 Comments
Filed under: ,
Wednesday, August 24, 2005 3:24 PM

Drag Once Databinding

Article written for CoDe magazine relating to the Drag Once Databinding features in Smart Client Applicaitons www.Code-Magazine.com/Article.aspx?quickid=0409051 Steve
Posted by SmartClientData | 0 Comments
Filed under: ,
Tuesday, August 16, 2005 8:50 PM

Increasing query time-outs with TableAdapters

Tuning your SQL queries for the best performance can be part of life when you’re writing a database application. Sometimes life is hard, and you just can’t get things running as quickly as you’d like. With the default command time-out at 30 seconds, how
Posted by SmartClientData | 5 Comments
Filed under:
Saturday, August 13, 2005 10:10 PM

Setting NullValue property for typed dataset

In Whidbey DataSet designer, you are able to set Typed DataColumn's NullValue property to the following values if the DataType is string 1 (Empty) 2 (Nothing) (null for C#) 3 (Throw exception) 4 any string you can type in. The first three options are
Posted by SmartClientData | 14 Comments
Filed under:
Friday, August 05, 2005 5:00 PM

Navigating a large DataSet with the Document Outline - Zoom

In 2005 we now have a new DataSet Designer. While we had planned to implement Zoom functionality it turned out to be more difficult then we had hoped. Long term we plan to leverage the new design framework that’s used by the Class designer. However, this
Posted by SmartClientData | 1 Comments
Filed under:
Wednesday, July 27, 2005 3:26 PM

TableAdapters will support TimeStamp Concurrency Checks

I’m happy to report that we were able to get TimeStamp comparison added. The issue we faced was by the time the DBCommandBuilder API stabilized we were in what we call UI freeze which means we couldn’t change UI elements without some major negotiating.
Posted by SmartClientData | 5 Comments
Filed under:
Monday, July 25, 2005 5:48 PM

Customizing the connection string for TableAdapters

Visual Studio 2005 now leverages the strongly typed settings file which wraps app.config. With connection strings stored in app.config/Settings, developers can centralize their connection strings across their application. Some advantages over VS2003 are:
Posted by SmartClientData | 15 Comments
Filed under:
Friday, July 15, 2005 4:05 AM

Databinding not happy with the object name containing dots

DataBinding does not work well with DataTable name with a "." The Dot in a DataTable name or a DataColumn name will not make the DataBinding happy. For example, if you drag drop a table from the DataSource window to a Windows Form, it would not create
Posted by SmartClientData | 0 Comments
Filed under:
More Posts Next page »
 
Page view tracker