Copying bulk data into SQL Server(dotnetbips.com)

submitted by skuv(40) 6 years, 3 months ago

Few weeks ago I (Bipin Joshi) released BinaryIntellect Bulk Copy Tool. Many visitors asked me how the tool is developed and hence I decided to write this article. Though the tool uses many other aspects of ADO.NET 2.0 the core thing is the new bulk copy class. Some applications require inserting huge data to SQL server databases. In such case executing independent INSERT queries is not an efficient way. SQL Server data provider allows you to perform such inserts using SqlBulkCopy class. This article explains with an example how this class can be used in your applications. read more...

add a comment |category: ASP.NET |Views: 13

tags: another

Adding Paging Functionality To DataList(dotnetbips.com)

submitted by skuv(40) 6 years, 3 months ago

ASP.NET DataList web control allows to display data in flexible way. One of the feature it lacks as compared with DataGrid is paging. This article explains you how to add such functionality to the DataList. read more...

add a comment |category: ASP.NET |Views: 101

tags: another

Persistent and Bidirectional Sorting In ASP.NET DataGrid(dotnetbips.com)

submitted by skuv(40) 6 years, 3 months ago

If you have work with sorting feature of ASP.NET DataGrid, you must have noticed that the sorting works only for the current page of the grid. As soon as you change the 'state' of the page the sorting is lost (For example when page index is changed). This is because the value of SortExpression is available only in SortCommand event. In order to persist the sorting we need to preserve this value some where. In addition to this we do not have in-built mechanism to perform bidirectional (ascending-descending) sorting. In this small article I will show you how to accomplish these tasks using ViewState object. read more...

1 comment |category: ASP.NET |Views: 5

tags: another

Creating DataGrid Programmatically(dotnetbips.com)

submitted by skuv(40) 6 years, 3 months ago

Generally ASP.NET DataGrid is placed on the web form at design time. You add the <asp:DataGrid> control to the web form and then add bound columns to it. However, some times it becomes necessary to create DataGrid via code and then add it to the web form. This articles will show you how to do just that. read more...

add a comment |category: ASP.NET |Views: 184

tags: another

Determine Web Visitors Country of Origin in the Drop Down List using .(dnzone.com)

submitted by skuv(40) 6 years, 3 months ago

With the emergence of online technologies such as the Internet, people and businesses have increased their reliance and use of these mediums as an avenue for commerce as it can be more convenient. During the transaction online, there are times when it is important to preset the web visitor's country of origin, ZIP code, ISP and domain name at the drop down list to prevent fraud and to ease the complexity of registration task. This article shows you how by using .NET Framework, it can be done. read more...

add a comment |category: ASP.NET |Views: 3

tags: another

Automate Tedious QuickBooks Tasks with COM-based API(devx.com)

submitted by skuv(40) 6 years, 3 months ago

Learn how to programmatically control QuickBooks using the COM-based QuickBooks SDK 5.0. You'll be able to free yourself from those time-consuming, repetitive QuickBooks task read more...

add a comment |category: ASP.NET |Views: 3

tags: another