Contents tagged with .NET
-
Inserting 40,000 records in MYSQL from Asp.Net
Recently I got a task of importing about 40,000 records for a fixed length delimited file to MY SQL database. Copying the data into a list of Business object was not a problem, but to insert about 40000 records in MYSQL in an asp.net application looked time consuming. More over this event would take place regularly and over 200 times a day and also user need to process the data after it has been uploaded.
-
Converting double to integer using cast and convert statement
Check out the code below.
-
Bankers Rounding in Math.Round Method
What would be the output of the following program? -
Using Enviroment.FastFail method to exit the corrupt application Process
Have you ever had some point in code where you want to exit the application immediately? Normally for this purpose you would use the Application.Exit method. But Microsoft has provided a better method for this purpose which not only just exits the application but also adds a message to the Windows Application event log.
-
Convert string to uppercase when comparing after normalizing instead of lowercase
While doing string comparison after normalizing (converting both string to upper case or lower case) we should always use the upper case. Upper case is optimized for normalization.
-
Finding Network statistics in Dot Net
Last few days while working with my broadband network (downloading few stuff) I wanted to check the exact amount of download per minute. I tried to check the data from task manager and resource monitor. But these gave data in terms of percentage of network use. Hence I could never find the exact amount of download.
-
Community Tech days on 11th July in Kolkata
-
All the posts in LINQ series
In Last few weeks I have done a few LINQ series Post. Here is a list of all the posts done.
-
LINQ and Aggregate function
LINQ also provides with itself important aggregate function. Aggregate function are function that are applied over a sequence like and return only one value like Average, count, sum, Maximum etc…
Below are some of the Aggregate functions provided with LINQ and example of their implementation. -
Working with Joins in LINQ
While working with data most of the time we have to work with relation between different lists of data. Many a times we want to fetch data from both the list at once. This requires us to make different kind of joins between the lists of data.