Welcome to MSDN Blogs Sign in | Join | Help

March 2009 - Posts

Friday, March 20, 2009 2:51 PM

Table-Value parameter used in .Net. Simple sample

Table-Value Parameters. One of those new things that I haven’t experimented with. Yet. So, I had a little bit of spare time so I thought I’d give it a try, turns out that this is really simple. Here is a really simple example on how to use them. . First
Posted by maspeng | 1 Comments
Thursday, March 19, 2009 3:51 PM

TechDays - Link to downloadable tools

Thanks to the brave people showing up for the first public presentation that I’ve done. Hope it was useful. If you have any further question, just post a comment or contact me via this blog. Here are the links to the tools used for the presentation I
Posted by maspeng | 1 Comments
Tuesday, March 03, 2009 2:49 PM

Pivot tables in SQL Server. A simple sample.

The other day I was wondering about how to use Pivot tables in SQL Server with SQL, and I didn’t find any simple examples on this. So I had to do my own and I thought I’d share this here and also as to have as a future reference for myself. So let’s start
Posted by maspeng | 2 Comments
Monday, March 02, 2009 2:21 PM

DataAdapter.Update returns 0 and doesn't update the table in SQL Server.

Short one today. Sometimes there are reports that the DataAdapter.Update(datatable) method returns 0 and that the backing table in the database doesn’t get updated. How come? On the client side we can clearly see that our added and modified rows have
Posted by maspeng | 1 Comments
 
Page view tracker