Reading and writing excel files and other Ado.Net tutorials

Mischa Kroon — Tue, 30 May 2006 10:06:00 GMT

I've known for some time now that it's possible to use Ado.Net to read from Excel files, I didn't know it was also possible to write to them.

At least I have found a workaround by using SQL server and registering Excel files as an external resource.

Reading and writing from excel.

Other Ado.Net tutorials.

I have no idea how this performs but it should be an interesting alternative to using the

Other methods of exporting data to excel.

Adding search to your ASP.Net site the easy way

Mischa Kroon — Tue, 06 Sep 2005 00:18:00 GMT

This is a great way to add search to a website, and it's so simple that you will probably love it.

The code needed:

string search = string.Format("http://beta.search.msn.com/results.aspx?q=site%3yoursitehere.com+{0}&format=rss",
HttpUtility.HtmlEncode(SearchText.Text));
RssFeed1.DataSource = search;
RssFeed1.DataBind();

RssFeed1 is a SKM RssFeed control which can be downloaded here.

Only thing to do after this is add some visually pleasing styles and your done.

An example of this in action can be found here.

This idea came from:
Ryan Farley's blog.

Search results matching tags 'General', 'Things from around the web', 'Things to try', and 'Asp.Net'

Reading and writing excel files and other Ado.Net tutorials

Adding search to your ASP.Net site the easy way