Community Blogs

Many of you have probably heard that we’ve released ASP.NET Ajax Preview 5 on Codeplex, and it’s available here . Aside from all the cool updates to the codebase, Preview 5 also includes some updated samples, as well as support for UpdatePanel when using ASP.NET 3.5 SP1. Previously, this didn’t work because of updates to the scripts for compatibility with 4.0. Now, with this fixed, you can easily add Ajax Preview 5 functionality to existing sites and enjoy continued operation. There is a very simple example included with the Preview 5 samples that demonstrates this functionality (8_UpdatePanel.aspx under the 1_Basic_DataView folder). I’ll quickly cover here how to get your existing UpdatePanel working with the new Preview bits. Basically, all...

I can't even tell you how many times over the last few years I have had to clone a row from one DataTable to another DataTable. To make this easier, I created a method that I can call at anytime to create this new DataRow and return a new DataTable back to me. I have another overload of this method that I can also pass in the new DataTable. In ADO.NET there is no easy way to take a single row from an existing DataTable and copy it to another DataTable. The major reason why it is not so easy is you can not add a DataRow that exists in one DataTable to another DataTable. As a result you must create a new DataRow object and copy all of the values from the original DataRow into this new one. You can then create a new DataTable (or use one with...

Brad Abrams - What is .NET RIA Services? - Business Apps Example for Silverlight 3 RTM and .NET RIA Services July Update, part1 , part2 , part3 , part4 , part5 , part6 , part7 - Simple Example of Managed Extensibility Framework (MEF) in Silverlight Rob Bagby - Azure Application, part1 (intro), part2 (Access Azure Table Storage), part3 (Expose (REST) Web Service And Consume in Silverlight) - Building An Azure Application From The Ground Up Dave Ward - Improving jQuery’s JSON performance and security - Never worry about ASP.NET AJAX’s .d again - 11 keystrokes that made my jQuery selector run 10x faster Joe Stagner - I’m asked, how did you learn what you know ? - Resources for learning the ADO.NET Entity Framework - More Entity Framework Resources...

  SyntaxC4 , this one is for you ! I’m planning for some work in NETOOP and digging into the ADO.NET Entity Framework. Since  SyntaxC4 asked for it – here is a list of stuff I’ve found. I have the 1st 3 books below and review will be coming Read More......( read more ) Read More...

Microsoft has made a huge announcement regarding the OracleClient library in ADO.NET. Himanshu Vasishth, Program Manager for ADO.NET OracleClient made the following information available in the ADO.NET Team Blog yesterday: As a part of formulating our long term strategy for ADO.NET, we have had several discussions with number of our customers, internal and external partners, and MVPs to better align our development efforts to ensure we are delivering the right technologies according to our customers’ highest priority needs. One of the key intent of these discussions and the associated research was to understand the needs and requirements of customers who develop applications with Oracle using “System.Data.OracleClient” (OracleClient). OracleClient...

The second day of DevDays and 5 more interesting sessions to follow. At 9:15 the first session of this day started it called “Functional Programming in C#” from Oliver Sturm . In this session we dived deep in to C# with a lot of C# 3.5 LINQ and lambda expressions. The question was, why would we use functional programming in C#, the answer was given with some practical examples. The second session of today was about “Building RESTful services with the ADO.NET Data Services “given by Jurgen Postelmans . ADO.NET Data Services is build on top of the Web Programming Model of WCF. In this session we find out how easily it is to create and consume REST data services on the web. In a few minutes you can create a service that exposed your data to the...

Through ODP.NET you can use Oracle's Associative Array feature. Unfortunately, there is a limitation: you cannot have associative arrays with an index type other that number. If you have this stored procedure: PACKAGE MyPackage AS TYPE AssocArrayVarchar2_t IS TABLE OF VARCHAR2 ( 20 ) INDEX BY BINARY_INTEGER ; PROCEDURE MyStoredProcedure ( Param1 IN AssocArrayVarchar2_t ); END MyPackage ; You can use this code to call it: using ( OracleConnection con = new OracleConnection ( @"DATA SOURCE=(DESCRIPTION=(ADDRESS=(COMMUNITY=MyCommunity)(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SID=MySid)));USER ID=MyUsername;PASSWORD=MyPassword;Promotable Transaction=local" )) using ( OracleCommand cmd = con.CreateCommand()) { con.Open...

There are times where you want to use a stored procedure that doesn’t return just normal rows out of a database.  One classic example is if you are doing Full-Text Searching and want to return the Rank. The first step to doing this is the get your Read More......( read more ) Read More...

The method below describes how to upload a file to a webserver and then import the file into SQL using either LinqToSQL or SQL Bulk Copy. The sample code only shows how to import xls and xlsx files but it could easily be extended to support csv files too.  Sample code is attached at the bottom. We will be uploading data from an Excel file containing columns CompanyName and Phone and loading that into the Northwind Shippers table. We’ll start by uploading the file to the webserver. This is done with the help of the FileUpload web control. The FileUpload control has a SaveAs method which saves the contents of the file into the location that we specify. The file will be stored in a temp folder under App_Data since App_Data is not browsable...

If you are using Oracle Database Provider for .NET (ODP.NET) and you want to use TransactionScope 'd transactions, you may have gotten the dreaded " Data provider internal error(-3000) [System.String] " exception. I'll explain how I fixed it. First, if you want to support distributed transactions, make sure you have the OracleMTSRecoveryService service installed and running on your machine (it comes with the Oracle Data Access Components installation), or any other machine on your network, as long as properly configured on the MSDTC tab on the Component Services applet. If you don't need distributed transactions, you can place the connection string setting PROMOTABLE TRANSACTION=LOCAL on your connection string, for example...