MySQL: How to search a value in the whole table.

If you want to search a value in the whole table:

1) You have to enable full text indexing on the columns.
2) Column types have to text/char/varchar.
3) Search by the MATCH() AGAINST() functions.
4) You cannot match text having length less than 4. There is a work around to it. I'll write about that later.

Details can be found here:

http://dev.mysql.com/doc/refman/5.0/en/fulltext-natural-language.html

ASP.net: XMLDataSource can only bind with DropDownList when the values are used as attributes.

If you want to bind a DropDownList with an XMLDataSource and your xml has the following structure:

<destination>

<location><>assets_UploadedFile1</location>

<location>assets_UploadedFile2</location>

<location>assets_UploadedFile3</location>

</destination>

Actually, you can't bind. You have to modify your xml file as to conform to the following format:

<destination>

<location name="assets_UploadedFile1">

<location name="assets_UploadedFile2">

<location name="assets_UploadedFile3">

</location>

Now you can easily bind the DropDownList to the XMLData Source by selection xPath="destination/location" .

ASP.NET and AJAX: File Upload in UpdatePanel, Does not work.

It does not work as expected because of some security issues. Details look at here:

http://geekswithblogs.net/ranganh/archive/2008/04/01/file-upload-in-updatepanel-asp.net-ajax.aspx

How to upload a file using ASP.net

Two easy ways to do that are:

1) Using ASP.net FileUpload Tool:
http://msdn.microsoft.com/en-us/library/aa479405.aspx

2) Using AJAX control Toolkit- AsyncFileUploader Tool:
http://www.asp.net/ajaxlibrary/HOW%20TO%20Use%20the%20AsyncFileUpload%20Control.ashx

** I believe when there are so many quality tutorials over the web, I do not really need to write one of my own unless the topic is something unique**

Get data from SQL Server Stored Procedure using LINQ.

http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx

** I believe when there are so many quality tutorials over the web, I do not really need to write one of my own unless the topic is something unique**

Get data from SQL Server using LINQ.

This link has a wonderful video tutorial. That is good enough to get a starting point.

http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx

** I believe when there are so many quality tutorials over the web, I do not really need to write one of my own unless the topic is something unique**

Starting with .Net Language Integrated Query (LINQ)

** I believe when there are so many quality tutorials over the web, I do not really need to write one of my own unless the topic is something unique**

http://msdn.microsoft.com/en-us/library/bb308959.aspx