My C# Corner

When you bind a GridView to an ObjectSource in ASP.NET, sometimes, you don't want to display all of the columns returned from the ObjectSource DataTable, but if you use a GridView and let it autmatically generate the columns, it becomes not a striaght forward deal to hide the individual selected columns. Here is a way to do that:

Simply catch the RowDataBound event on the GridView and if you know the index of the column to hide, just use it as follows:

I recently stumbled across the following C# code that allows sorting and filtering rows in a DataTable using DataTable.Select method:

http://authors.aspalliance.com/olson/methods/FilterSortData.aspx

However, what I needed was to sort on a primary column, then if DataRows had the same value for the primary column, perform a secondary sort based on another secondary column.

Not many people know that you can use your simple Windows Explorer with as an FTP client to upload and download files... Well maybe I'm the only one who doesn't know, but it surely made my day today when I found out.

The nice thing about using Windows Explorer as an FTP client is that you get all the drag and drop features that come with it, while uploading and downloading remotely, and no need to buy an FTP client software.

I recently finished working on a YouTube-like project where you can upload any video file (mpeg, avi...etc.) and automatically convert it into FLV then display a link to the converted video into an online flash movie player.

The project involved using the free open source utility ffmpeg along with some other utilities from around the net. In addition it shows upload progress as the user is uploading the movie file.

We all know in ASP.NET, to get the absolute path from the relative path, you can prefix your relative path with the Tilde character as follows:

MyHyperLink.NavigateUrl = "~/Catalog/ASP/Products";

I'm currently organizing an MS Access database and setting up some SQL queries that export data into CSV files for Yahoo Store. One of the things I had to do was to create fields in the CSV file that are compound of other existing fields in the database, and some that even depended on the existence of other physical fields in the Access database.

Using LIKE statement in an SQL query requires specifying wild cards in the search pattern. In C# .NET, the wild card is %, however if you are building your SQL query directly from MS Access, I found out you need to use the asterisk (*) instead of (%) wild card to achieve the same result.

We all had to use Thread.Sleep at one point or another to wait on an event to happen, or to satisfy a configuration setting during cyclic calculations or a processing. But is your worker thread sleeping too much? Does it feel sometimes that your code sleeps in the wrong time

Here is a list of all the free utlities & user controls developed and published on http://www.mycsharpcorner.com . More will be coming soon, but for now, here is a quick list:

Social Links User Control in ASP.NET - Read the related article

If you have done SEO work, you know that Search Engines would penalize my site if both http://www.mycsharpcorner.com and http://mycsharpcorner.com/ requests returned a 200 OK code in the HTTP header. Why? Because from a Search Engine's spider point of view, there are 2 sites, one with the www prefix, and one without it, yet in reality they the same site. So what’s wrong if the Search Engine thinks

Well, this is not a programming tip; it is more of a general Excel tip from a recent assignment I had for one of my clients. I had an Excel document with two columns; one needed be calculated from the other based on a percentage formula, so:

SalePriceColumn=OriginalPriceColumn + 15% extra

Do you like the social links bar on top of this article? Do you hate it? In today's internet blog, you almost never miss seeing a "Digg It", a "Kick it", a "Ridd It" a Furl it, burl it...or squirrel it... link or icon at the end of each article you read in someone's blog. Well, regardless of the opinions people might have about this phenomenon, if you are an ASP.NET programmer like me, your concern would probably be over how to construct the "social-butterfly" user control, rather than

It's been three weeks since I started this project, and I've been curious to see how the site is being used, and how many people are visiting... what are they reading...etc. So I started a small little project on the side, called the Traffic Tracker.