Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

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
Thursday, April 06, 2006 5:38 PM

SQL Server Everywhere - SQL Mobile Unleashed

Today Paul Flessner announced that SQL Mobile will be released as SQL Server Everywhere Edition. http://www.microsoft.com/sql/letter.mspx Details are yet to be announced. But to get a feel for what the new product will do, check out this walkthrough:
Posted by Steve.Lasker | 0 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: ,
Monday, February 13, 2006 8:31 AM

Relation Dialog: Relation Only, or with Foreign Key Constraint?

Using the Relation Dialog, you are asked to choose Relation Only, Foreign Key Constraint Only, or Both. Which is the right choice? “Relation Only” makes available the tables related to the table that you are working with. This means that if you are working
Posted by SmartClientData | 1 Comments
Wednesday, February 01, 2006 9:31 PM

VSLive San Francisco Presentations

At VSLive I presented two sessions. One for Occasionally Connected Smart Clients and another on Advancements in Data Access. The Occasionally Connected Smart Client session focused on what we’re working on post VS 2005. Some of which should be in Orcas,
Posted by SmartClientData | 7 Comments
Attachment(s): VSLiveDemosAndSlides.zip
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
Tuesday, November 22, 2005 7:29 PM

Building SQL manually considered harmful

I just got done fixing a painful bug. The long and short of it is that I had code like this (simplified a lot for brevity): Public Sub StoreSyncDate() Dim sql As String = "insert into SyncTimes (ObjectID, SyncDate) values ({0}, '{1}')" sql = String.Format(sql,
Posted by SmartClientData | 3 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:
Wednesday, November 02, 2005 5:23 PM

Installing Northwind on SqlExpress

When performing a default install of Visual Studio 2005 an instance of Sql Server Express edition is installed. Unfortunately there are no sample databases included with Sql Express. ( http://lab.msdn.microsoft.com/express/sql/ ) I've had more than a
Posted by SmartClientData | 23 Comments
Monday, October 31, 2005 9:42 PM

Returning the identity column value from a TableAdapter DBDirect method

A common scenario when using tables with an auto-increment primary key is to get the value of the identity column for the row you just inserted. Sometimes you can't, or don't want to, use DataSets, which is why we created the DBDirect methods on the TableAdapter.
Posted by SmartClientData | 4 Comments
Friday, October 14, 2005 9:49 PM

Why is my column named _Region in the Typed DataSet?

One quirk you'll find when making a typed DataSet with a column or table named "Region" is that the generated code produces a property called "_Region". What's up with that? If you read Raymond Chen's blog , you already have a pretty good guess: Backward
Posted by SmartClientData | 2 Comments
Friday, October 07, 2005 3:41 AM

Case sensitive or not sensitive

In a Dataset, case sensitive seems only apply to the data not to the schema Within a dataset, table and column names are by default case-insensitive — that is, a table in a dataset called "Customers" can also be referred to as "customers." This matches
Posted by SmartClientData | 3 Comments
Monday, September 19, 2005 11:01 PM

Performance tip for databound UI

When loading large amounts of data into a dataset table with databound UI, things can get pretty slow. One reason is that each time a row is added to the table, the databinding components will perform some work and tell the databound controls that a new
Posted by SmartClientData | 5 Comments
More Posts Next page »
 
Page view tracker