Web Development

<connectionStrings>
	<clear/>
	<add name="ADConn" providername="System.Data.SqlClient" connectionstring="Data Source=YourDataSource;Integrated Security=true; Persist Security Info=True;User ID=YourUserID;User Instance=true"/>
</connectionStrings>

Public Shared Function GetConnectionString(ByVal strConnection As String) As String
       Dim strReturn As New String("")
       If Not String.IsNullOrEmpty(strConnection) Then
           strReturn = _
           ConfigurationManager.ConnectionStrings(strConnection).ConnectionString
       Else
           strReturn = _
           ConfigurationManager.ConnectionStrings("YourDefaultConnection").ConnectionString
       End If
       Return strReturn
   End Function

Pete O`Hanlon wrote:

If you do a select count on a busy database, by the time you do your actual select of the records the criteria may return different results because of inserts, updates or deletes.

<SCRIPT LANGUAGE="Javascript">
<!--

var flashinstalled = 0;
var flashversion = 0;
MSDetect = "false";
if (navigator.plugins && navigator.plugins.length)
{
	x = navigator.plugins["Shockwave Flash"];
	if (x)
	{
		flashinstalled = 2;
		if (x.description)
		{
			y = x.description;
			flashversion = y.charAt(y.indexOf('.')-1);
		}
	}
	else
		flashinstalled = 1;
	if (navigator.plugins["Shockwave Flash 2.0"])
	{
		flashinstalled = 2;
		flashversion = 2;
	}
}
else if (navigator.mimeTypes && navigator.mimeTypes.length)
{
	x = navigator.mimeTypes['application/x-shockwave-flash'];
	if (x && x.enabledPlugin)
		flashinstalled = 2;
	else
		flashinstalled = 1;
}
else
	MSDetect = "true";

// -->
</SCRIPT>