Good site for DB Connection Strings

This site is good place to find the connection string for your DB: http://www.connectionstrings.com/

ZAP: a Tool for Generating ASP.NET Websites Automatically

ZAP - a small tool is very useful for coding reuse. It is a free tool that you can use to generate ASP.NET websites automatically. The tool generates a user interface, business logic, and data access layer automatically based on a configuration file.

Transferring Data Using SqlBulkCopy Class

Good article shows how to use SqlBulkCopy Class: Transferring Data Using SqlBulkCopy Class

Creating Publisher Certificates For ClickOnce

Just found a very useful article for ClickOnce: Creating Publisher Certificates For ClickOnce.

Some quoting from this article:

There is a good article - “Configuring ClickOnce Trusted Publishers“ by Brian Noyes published on MSDN.

Framework SDK contains tool MakeCert. Here is the command line to make a certificate similar to one created by VS:

makecert -r -pe -a sha1 -n "CN=yourcompany" -b 01/01/2000 -e 01/01/2036 -eku 1.3.6.1.5.5.7.3.3 -ss My

The -b and -e option specify the time period when certificate is valid. The -eku option specifies the certificate is intended for code signing. The -a sha1 option is to set the same algorithm that VS uses.

It's important to use the -pe option which allows to export the private key from the certificate. To do this use CertMgr (another tool from Framework SDK). The new certificate will be installed in your personal store. Select it and click on the Export button. Click Next on the first page, and on the second select to export the private key. On the next one you can select some additional options; if not sure just leave on default. After that you will be asked to type password for the file; can be left blank. On the last one specify the file name and location. Finish the wizard and you should get a .pfx file that can be used in VS or imported on user machines.

Open IE for a specific URL in C#

The Simplest way is (works very well):

System.Diagnostics.Process.Start(sURL);

But this will open the default browser in your system.

Another way is create Internet Explorer Application using shdocvw.dll:

using SHDocVw; // Contains the Internet Explorer reference

InternetExplorer oIE = new InternetExplorer();

if (oIE != null)
{
object oEmpty = String.Empty;
object oURL= sURL;
oIE.Visible = true;
oIE.Navigate2 (ref oURL, ref oEmpty, ref oEmpty, ref oEmpty, ref oEmpty);
}

Complaining Studio 2005 Text Editor too slow?

Probably this fix can help: go to Tools->Options->Text Editor->C#->General and unchecking the “Navigation bar” option and "WordWrap". It seems there is some issues with the navigation bar.

Build Project Templates Using Visual Studio 2005

Found two good articles about creating project templates in VS 2005.

Speed Up with Project Templates Using Visual Studio 2005 - Part 2

Speed Up with Project Templates Using Visual Studio 2005 - Part 3

Free tools to convert video to FLV

Free tools for FLV:

ffmpeg: converting vedio format to FLV;

flvtool2: fixing FLV index.

Little Planet Finder

Planet finder applet for fun.

http://www.lightandmatter.com/area2planet.shtml

FLV Flash video streaming with ASP.NET 2.0 / IIS and HTTP handler

Found one HTTP handler for FLV.

FLV Flash video streaming with ASP.NET 2.0 / IIS and HTTP handler

Flash Video Player

Just found something about Flash Video Player. FLV is the best video format for Internet video sharing and playing. It needs less bandwidth than other formats.

Flash Video Player

Free FLV Encoder - Riva VX

Flash Video (FLV) Anti-Aliasing

Google lauched code search

Google lauched a new search: code search. It seems helpful for programmers to search code sample or snippets.

Why DVD+R(W) is superior to DVD-R(W) -

Just found a good article discuss "Why DVD+R(W) is superior to DVD-R(W) -". It is good to read.

Tools for the Power Developer

Just happen to see this interesting article: Web Development Tools for the Power Developer.

These tools might be useful for Web Development.

Web Developer extension for Firefox

Internet Explorer Developer Toolbar

"Atlas" 1.0 Naming and Roadmap

From ScottGu's Blog, Atlas now has an official name and roadmap. Microsoft will ship "Atlas" 1.0 soon.

Serial Port programming

Today we got a Barcode Scanner w/ RS232. Just getting some idea how to use it in our system. I found some very useful information about SerialPort (RS-232 Serial COM Port) in C# .NET. We use MSComm control in VB6 to do this. Now in .Net Framework 2.0, we have this new and cool SerialPort component.

ClickOnce Installs fail, "ADODB 7.0.3300 required"?

Today I used ClickOnce to publish a new version of my project. But it failed. The error says:

"Unable to install or run the application. The application requies the assembly ADODB 7.0.3300 to be installed in the Global Assembly Cache (GAC) first."

I tried to find the ADODB 7.0.3300. But no way I can find it. The only thing I added to project is Report Viewer. So I removed the reference to ReportViewer, and tried again. It worked. It seems the ReportViewer references this mysterious ADODB 7.0.3300.

An Introduction to AJAX Techniques and Frameworks for ASP.NET

This article introduces AJAX to ASP.NET developers implementing an example web page in different ways using ASP.NET Atlas, ASP.NET callbacks, Ajax.Net, Anthem.Net and MagicAjax.Net.

Details on CSS changes for IE7

IEBlog has a good post about CSS changes for IE7 recently. This might be very helpful for changing your site for IE7.

Use ClickOnce for VB6 Program

I found two good articles on MSDN today. They are talking about using the .NET Framework 2.0 and ClickOnce deployment to automatically update Visual Basic 6.0 applications and COM objects.

Automatically Updating Visual Basic 6 Applications: Part I

Automatic Updating of Visual Basic Applications: Part II