Browse by Tags - Microsoft All-In-One Code Framework - Site Home - MSDN Blogs
Microsoft Blog Images
Microsoft All-In-One Code Framework - Developers' Pain Killer
Who We Are
How We Kill Developers' Pains
Sample Request Service
Sample of the Day
Global Microsoft Next 2011
3 Years, 5M Downloads
Search this blog
Search all blogs
Browse by Tags
Windows Phone 8
Windows Phone Development
Windows Store app Development
Email Blog Author
RSS for posts
RSS for comments
Tagged Content List
[Sample Of Apr 9th] How to create and execute SqlCommand in ADO.NET
Sample Download : http://code.msdn.microsoft.com/How-to-Create-and-Execute-86922261 We can create and execute different types of SqlCommand. In this applilcation, we will demonstrate how to create and execute SqlCommand: 1. Create different types of SqlCommand; 2. Execute SqlCommand in different...
10 Apr 2014
[Sample Of Mar 24th] How to retrieve the Identity value after inserting a data using ADO.NET
Sample Download : http://code.msdn.microsoft.com/How-to-Retrieve-the-511acece We often set a column as identity column when the values in the column must be unique. And sometimes we need the identity values of new data. In this application, we will demonstrate how to retrieve the identity values:...
25 Mar 2014
[Sample Of Mar 17th] How to Use DbDataReader.GetInt32 Method
Sample Download : http://code.msdn.microsoft.com/How-to-Use-DbDataReaderGetI-dd8b52e9 DbDataReader.GetInt32 Method gets the value of the specified column as a 32-bit signed integer. In this snippet, we will demonstrate how to use DbDataReader.GetInt32 Method . 1. Create DbConnection , DbCommand...
18 Mar 2014
[Sample Of Mar 14th] How to Use IDataAdapter.GetFillParameters Method
Sample Download : http://code.msdn.microsoft.com/How-to-Use-IDataAdapterGetF-9b8e4be9 N ow there’s no code about the IDataAdapter.GetFillParameters Method in MSDN, and the customers want it. In this snippet code, we will demonstrate how to use the IDataAdapter.GetFillParameters method: 1...
14 Mar 2014
[Sample Of Mar 4th] How to Get Schema Information from Database
Sample Download : http://code.msdn.microsoft.com/How-to-Get-Schema-b66d62e2 Sometimes we may need the schema information of the database, tables or some columns. In this application, we will demonstrate how to get schema information from database: 1. In this application, we will use the SqlConnection...
5 Mar 2014
[Sample Of Feb 24th] How to Use IDataRecord.GetDataTypeName Method
Sample Download : http://code.msdn.microsoft.com/How-to-Use-IDataRecordGetDa-7168b1cf Now there’s no code about the IDataRecord.GetDataTypeName Method in MSDN, and the customers want it. In this snippet code, we will demonstrate how to use the DbDataReader.GetInt32 method: 1. Create DbConnection...
24 Feb 2014
[Sample Of Nov 26th] How to Store Data of DataSet into XML File
Sample Download : http://code.msdn.microsoft.com/How-to-Store-Data-of-7b9710f3 In this sample, we will demonstrate how to write data into XML file from DataSet and read data into DataSet from XML. 1. We will create one dataset with two tables. 2. We will use two ways to export dataset into the...
26 Nov 2013
[Sample Of Nov 25th] How to modify data in DataTable and update to the data source
Sample Download : http://code.msdn.microsoft.com/How-to-modify-data-in-c68d35f4 We have several ways to modify the data in DataTable. In this application, we will demonstrate how to use different ways to modify data in DataTable and update to the source. 1. We use SqlDataAdapter to fill the DataTables...
25 Nov 2013
[Sample Of Nov 22nd] How to use SqlDependency to get the notification in Entity Framework
Sample Download : CS Version: http://code.msdn.microsoft.com/How-to-use-SqlDependency-5c0da0b3 VB Version: http://code.msdn.microsoft.com/How-to-use-SqlDependency-f4b8eb43 We can use the Sqldependency to get the notification when the data is changed in database, but EF doesn't have the same...
22 Nov 2013
[Sample Of Sep 8th] How to fill a DataTable with the result of LinqToEntity
Sample Download : http://code.msdn.microsoft.com/How-to-fill-a-DataTable-b0a4feb0 This sample demonstrates how to fill a DataTable with the result of the Linq to Entity query. Linq to Entity is a simple way for the developers, but sometimes we need to use the DataTable. In this sample, we demonstrate...
8 Sep 2013
[Sample Of Sep 5th] How to retrieve output parameter from stored procedure in Entity Framework
Sample Download : http://code.msdn.microsoft.com/How-to-retrieve-output-e85526ba This sample demonstrates how to use ObjectParameter instance to get the value of output parameter in Entity Framework. You can find more code samples that demonstrate the most typical programming scenarios by using...
5 Sep 2013
[Sample Of Jun 5th] How to use IsolationLevel Enumeration in DbTransaction
Sample Download : http://code.msdn.microsoft.com/How-to-use-IsolationLevel-36783d30 In this application, we will demonstrate how to use the IsolationLevel Enumeration in DbTransaction. We will show you which of the following behaviors are allowed in the different isolation levels. 1. Dirty reads;...
5 Jun 2013
[Sample Of Apr 29th] How to create DataTable manually with specific schema definitions
Sample Download : http://code.msdn.microsoft.com/How-to-create-DataTable-25f6c390 Sometimes we may need to create the DataTable manually and some specific schema definitions, such as Foreign Key constraints, expression columns and so on. In this sample, we will demonstrate how to create the DataTable...
29 Apr 2013
[Sample Of Apr 18th] How to use DataAdapter to retrieve and update the data
Sample Download : http://code.msdn.microsoft.com/How-to-use-DataAdapter-to-e1cd35c1 We can use DataAdapter to retrieve and update the data, and sometimes the features of DataAdapter make some specific operations easier. In this sample, we will demonstrate how to use DataAdapter to retrieve and...
19 Apr 2013
Page 1 of 1 (14 items)
© 2015 Microsoft Corporation.
Privacy & Cookies