Tips & Tricks

Advanced url rewriting for the rest of us - how to create a custom transform in UrlRewriter.net

rtpHarry — Sun, 08 Nov 2009 17:12:21 GMT

At first glance url rewriting can be a daunting task, but today we will see that it doesn't have to be. Every developer desires clean urls for their apps but because its not built into the language in a straight forward way its usually left on the "nice to haves" list. I am going to take you on a tour of the UrlRewriter.net library from the theory to implementing it in your website.

http://runtingsproper.blogspot.com/2009/11/advanced-url-rewriting-for-rest-of-us.html

It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level

ranganh — Fri, 10 Dec 2004 07:23:25 GMT

You may get this error when trying to browse an asp.net application.

The debug information shows that "This error can be caused by a virtual directory not being configured as an application in IIS."

However, this error occurs primarily out of 2 scenarios.

1. When you create an new web application using visual studio.net, it automatically creates the virtual directory and configures it as an application. However, if you manually create the virtual directory and it is not configured as an application, then you will not be able to browse the application and may get the above error. The debug information you get as mentioned above, is applicable to this scenario.

To resolve it, Right Click on the virtual directory - select properties and then click on
"Create" next to the "Application" Label and the textbox. It will automatically create the "application" using the virtual directory's name. Now the application can be accessed.

2. When you have sub-directories in your application, you can have web.config file for the sub-directory. However, there are certain properties which cannot be set in the web.config of the sub-directory such as authentication, session state (you may see that the error message shows the line number where the authentication or sessionstate is declared in the web.config of the sub-directory). The reason is, these settings cannot be overridden at the sub-directory level unless the sub-directory is also configured as an application (as mentioned in the above point).

Mostly we have the practice of adding web.config in the sub-directory if we want to protect access to the sub-directory files (say, the directory is admin and we wish to protect the admin pages from unathorized users).

But actually, this can be achieved in the web.config at the application's root level itself, by specifing the location path tags and authorization, as follows:-



<location path="Admin">


    <system.web>


      <authorization>


	<allow roles="administrators" />


	<deny users="*" />


      </authorization>


    </system.web>


</location>

However, if you wish to have a web.config at the sub-directory level and protect the sub-directory, you can just specify the Authorization mode as follows:-



<configuration>


<system.web>


<authorization>


     <allow roles="administrators" />


     <deny users="*" />


 </authorization>


</system.web>


</configuration>

Thus you can protect the sub-directory from unauthorized access.

Cheers.

error: 26 - Error Locating Server/Instance Specified

kutting — Wed, 02 Dec 2009 05:21:15 GMT

Hi Guys,

If you are facing problem with connecting to SQL Server through ur application. And getting following error

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"

Step 1.

Check if you can login to your SQL Server Managed Studio using ur user Name and pwd.

Example using ur sa account which is ur default account

If not the then follow following steps

Change the authentication mode to mixed from Windows, Following are the steps to be followed.

In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
On the Security page, under Server authentication, select the new server authentication mode "SQL Server and Windows Authentication mode", and then click OK.
In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server

To Enable the sa login.

In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.
On the General page, you might have to create and confirm a password for the sa login.
On the Status page, in the Login section, click Enabled, and then click OK.

Step 2.

Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition

You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps:

Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

Note Click OK when you receive the following message:
Changes to Connection Settings will not take effect until you restart the Database Engine service.
On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

Step 3.

Enable the SQL Server Browser service

If you are running SQL Server 2005 by using an instance name and you are not using a specific TCP/IP port number in your connection string, you must enable the SQL Server Browser service to allow for remote connections. For example, SQL Server 2005 Express is installed with a default instance name of Computer Name\SQLEXPRESS. You are only required to enable the SQL Server Browser service one time, regardless of how many instances of SQL Server 2005 you are running. To enable the SQL Server Browser service, follow these steps.

Important These steps may increase your security risk. These steps may also make your computer or your network more vulnerable to attack by malicious users or by malicious software such as viruses. We recommend the process that this article describes to enable programs to operate as they are designed to, or to implement specific program capabilities. Before you make these changes, we recommend that you evaluate the risks that are associated with implementing this process in your particular environment. If you choose to implement this process, take any appropriate additional steps to help protect your system. We recommend that you use this process only if you really require this process.

Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
On the Surface Area Configuration for Services and Connections page, click SQL Server Browser, click Automatic for Startup type, and then click Apply.

Note When you click the Automatic option, the SQL Server Browser service starts automatically every time that you start Microsoft Windows.
Click Start, and then click OK.

Note When you run the SQL Server Browser service on a computer, the computer displays the instance names and the connection information for each instance of SQL Server that is running on the computer. This risk can be reduced by not enabling the SQL Server Browser service and by connecting to the instance of SQL Server directly through an assigned TCP port. Connecting directly to an instance of SQL Server through a TCP port is beyond the scope of this article. For more information about the SQL Server Browser server and connecting to an instance of SQL Server, see the following topics in SQL Server Books Online:

SQL Server Browser Service
Connecting to the SQL Server Database Engine
Client Network Configuration

Step 4.

Create exceptions in Windows Firewall

These steps apply to the version of Windows Firewall that is included in Windows XP Service Pack 2 (SP2) and in Windows Server 2003. If you are using a different firewall system, see your firewall documentation for more information.

If you are running a firewall on the computer that is running SQL Server 2005, external connections to SQL Server 2005 will be blocked unless SQL Server 2005 and the SQL Server Browser service can communicate through the firewall. You must create an exception for each instance of SQL Server 2005 that you want to accept remote connections and an exception for the SQL Server Browser service.

SQL Server 2005 uses an instance ID as part of the path when you install its program files. To create an exception for each instance of SQL Server, you must identify the correct instance ID. To obtain an instance ID, follow these steps:

Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
In SQL Server Configuration Manager, click the SQL Server Browser service in the right pane, right-click the instance name in the main window, and then click Properties.
On the SQL Server Browser Properties page, click the Advanced tab, locate the instance ID in the property list, and then click OK.

To open Windows Firewall, click Start, click Run, type firewall.cpl, and then click OK

Step 5.

Create an exception for SQL Server 2005 in Windows Firewall

To create an exception for SQL Server 2005 in Windows Firewall, follow these steps:

In Windows Firewall, click the Exceptions tab, and then click Add Program.
In the Add a Program window, click Browse.
Click the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe executable program, click Open, and then click OK.

Note The path may be different depending on where SQL Server 2005 is installed. MSSQL.1 is a placeholder for the instance ID that you obtained in step 3 of the previous procedure.
Repeat steps 1 through 3 for each instance of SQL Server 2005 that needs an exception.

Create an exception for the SQL Server Browser service in Windows Firewall

To create an exception for the SQL Server Browser service in Windows Firewall, follow these steps:

In Windows Firewall, click the Exceptions tab, and then click Add Program.
In the Add a Program window, click Browse.
Click the C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe executable program, click Open, and then click OK.

Reflection For Information On Constants

mkamoski — Tue, 01 Dec 2009 18:55:00 GMT

using System;
using System.Collections;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Collections.Specialized;
using System.Configuration;
using System.Data;
using System.Diagnostics;
using System.Drawing;
using System.IO;
using System.Reflection;
using System.Text;
using System.Web;

namespace Test.Abcd.Common.Core
{
	/// <summary>
	/// This provides generic services for Reflection.
	/// </summary>
	public static class ReflectionHelper
	{
		#region HelperMethods

		/// <summary>
		/// This returns FieldInfo for constants in a given type.
		/// </summary>
		/// <param name="targetType">This is the type to use.</param>
		/// <returns>This is an array of FieldInfo objects.</returns>
		/// <remarks>
		/// Note that this code was refactored from code found on 20091201 at the following link...
		/// http://weblogs.asp.net/whaggard/archive/2003/02/20/2708.aspx
		/// </remarks>
		public static FieldInfo[] GetConstantFieldInfoArray(System.Type targetType)
		{
			//The "BindingFlags.Public" gets all public fields.
			//The "BindingFlags.Static" gets all static fields.
			//The "BindingFlags.FlattenHierarchy" gets fields from all base types.
			FieldInfo[] myFields = targetType.GetFields(BindingFlags.Public | BindingFlags.Static | BindingFlags.FlattenHierarchy);

			ArrayList myConstants = new ArrayList();

			//Go through the list and only pick out the constants.
			foreach (FieldInfo myFieldInfoTemp in myFields)
			{
				// IsLiteral determines if its value is written at compile time and not changeable.
				// IsInitOnly determine if the field can be set in the body of the constructor.
				// For C#, a field with the readonly keyword would have IsLiteral=true and IsInitOnly=true.
				// For C#, a const field would have IsLiteral=true and IsInitOnly=false.
				if ((myFieldInfoTemp.IsLiteral) && (!myFieldInfoTemp.IsInitOnly))
				{
					myConstants.Add(myFieldInfoTemp);
				}
			}

			// Return an array of FieldInfos
			return (FieldInfo[])myConstants.ToArray(typeof(FieldInfo));
		}

		/// <summary>
		/// This will get the values of all the constants in the given type.
		/// </summary>
		/// <param name="targetType">This is the type to use.</param>
		/// <param name="convertToLowercase">This is a flag indicating if the values should be converted to lowercase or not.</param>
		/// <param name="trimWhitespace">This is a flag indicating if the values should be whitespace-trimmed or not.</param>
		/// <returns>This a collection of the values.</returns>
		/// <remarks>
		/// Note this will only work if the underlying type for the constants is "string".
		/// </remarks>
		public static StringCollection GetConstantValueStringCollection(System.Type targetType, bool convertToLowercase, bool trimWhitespace)
		{
			StringCollection myCollection = null;

			FieldInfo[] myFieldInfoArray = Team.Framework.Common.Core.ReflectionHelper.GetConstantFieldInfoArray(targetType);
			string myValueStringTemp = "";
			object myValueObjectTemp = null;
			int myLoopIndex = 0;
			myCollection = new StringCollection();

			foreach (FieldInfo myFieldInfoTemp in myFieldInfoArray)
			{
				myValueObjectTemp = null;
				myValueStringTemp = "";

				if (myFieldInfoTemp == null)
				{
					throw new System.ApplicationException("The current object, myFieldInfoTemp, is null.");
				}

				myValueObjectTemp = myFieldInfoTemp.GetValue(null);
				Debug.WriteLine("myLoopIndex='" + myLoopIndex.ToString() + "'");

				if (myValueObjectTemp == null)
				{
					myValueStringTemp = "";
					Debug.WriteLine("myValueObjectTemp == null");
					Debug.WriteLine("myValueStringTemp='" + myValueStringTemp + "'");
				}
				else
				{
					myValueStringTemp = myValueObjectTemp.ToString();

					if (convertToLowercase)
					{
						myValueStringTemp = myValueStringTemp.ToLower();
					}

					if (trimWhitespace)
					{
						myValueStringTemp = myValueStringTemp.Trim();
					}

					Debug.WriteLine("myValueObjectTemp != null");
					Debug.WriteLine("myValueStringTemp='" + myValueStringTemp + "'");
				}

				myCollection.Add(myValueStringTemp);
				myLoopIndex = myLoopIndex + 1;
			}

			return myCollection;
		}

		#endregion //HelperMethods
	}
}

http://mkamoski1.wordpress.com/2009/12/01/reflection-for-information-on-constants/

HTH.

Thank you.

-- Mark Kamoski

code for single fileupload ..$

kapiltapa — Wed, 25 Nov 2009 09:16:47 GMT

                    if (fuimage.HasFile)
                    {
                        Byte[] bytes = fuimage.FileBytes;
                        MemoryStream ms = new MemoryStream(bytes);
                        System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
                        string imagename = fuimage.FileName;
                        string dirpath = System.Web.HttpContext.Current.Server.MapPath("\\Photos\\Communities\\" + pout.ToString());
                        DirectoryInfo drinfo = new DirectoryInfo("" + dirpath + "");
                        if (!drinfo.Exists)
                        {
                            drinfo.Create();
                        }
                        string serverpath = dirpath + "\\" + imagename;
                        img.Save(serverpath);
                        string dbpath = "~/Photos/Communities/" + pout.ToString() + "/" + imagename;
                       // dalcommunities.UpdateImagePathByCommunity_ID(pout, dbpath);
                        dalcommunities.UpdateImagepathByCommunity_ID(pout, dbpath);

                    }

How to save the state of tabs.

roman_kht — Sun, 29 Nov 2009 12:35:06 GMT

For long while I had been searching for some easy way to save the state of tabs in asp.net(specifically ajax tab control). The only way to do was to save the save in viewstate (which will not work if for some reasons viewstate is disabled in page).

While I was going through one article on msdn library, I found something interesting which could be used to solve this problem.

The solution is to use CONTROL STATE.

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

For example, if you have written a custom control that has different tabs that show different information, in order for that control to work as expected, the control needs to know which tab is selected between round trips. The ViewState property can be used for this purpose, but view state can be turned off at a page level by developers, effectively breaking your control. To solve this, the ASP.NET page framework exposes a feature in ASP.NET called control state.

The ControlState property allows you to persist property information that is specific to a control and cannot be turned off like the ViewState property.

The following example shows a custom control that stores a value in control state.

HOW TO: Build a dynamic gridView at runtime

Crouchin9Tiger — Wed, 23 Aug 2006 19:33:03 GMT

The following example demonstrates how to build a grid view dynamically at runtime.

' Get the connection string, In this case it's comming from the web.config file

Dim

strCon As String = System.Configuration.ConfigurationManager.ConnectionStrings("con").ConnectionString

Dim con As New SqlConnection(strCon)

Dim cmd As New SqlCommand("[SEL_Results]", con)

cmd.CommandType = Data.CommandType.StoredProcedure

Dim yourParameter As SqlParameter = cmd.Parameters.Add("@yourParameter", Data.SqlDbType.VarChar)

yourParameter.Value = theValue

'Setting the dataAdapter to the sqlCommand.

Dim da As New SqlDataAdapter(cmd)

Dim ds As New DataSet

Try

con.open()

da.Fill(ds)

Catch ex As Exception

Finally

con.Close()

End Try

Dim dc As DataColumn

If ds.Tables.Count > 0 Then

'Building all the columns in the table.

For Each dc In ds.Tables(0).Columns

Dim bField As New BoundField

'Initalize the DataField value.

bField.DataField = dc.ColumnName

'Initialize the HeaderText field value.

bField.HeaderText = dc.ColumnName

'Add the newly created bound field to the GridView.

grdView.Columns.Add(bField)

End If

'Setting the dataSource of the grid here.

grdView.DataSource = ds.Tables(0)

grdView.dataBind()

To add sorting and paging to the gridView take a look at this article written by StrongTypes:

http://forums.asp.net/thread/1177923.aspx

Enjoy!

Reducing size of ASP.NET pages

ajay.ms2000 — Sat, 21 Nov 2009 19:52:39 GMT

We all know when a page is requested, ASP.NET process the page, its server controls and finally sends the Html to the client side for the browser to render it. The time taken to download the html to client side depends mainly on its final size. If your page is data rich, it would take much time to fetch it. So here I am presenting a technique to reduce the sizes of the pages.

When you see the pages html source by clicking the “View Source” in the browser, you could see that there are a lot of white spaces on the left side of each line on the html. This is actually a waste. Try saving the html page to your desktop and notice its size. Then delete all the spaces on the left side and then watch its size. You could see that the size of the page reduces considerably, sometimes more than 50%!! (watch the view source of Orkut in the browser).

Here is a technique to achieve the same.

1. Create a class in the App_Code, that is deriving from “System.Web.UI.Page” class.

public class MyPageBase : System.Web.UI.Page
{
}

2. Replace “System.Web.UI.Page” from all your web pages (.aspx.cs) and put MyPageBase. Means now all your webpages are deriving from MyPageBase.

3. Override the Render function in this class

public class MyPageBase : System.Web.UI.Page
{
    protected override void Render(HtmlTextWriter writer)
    {
    }
}

4. Place the below code inside the function and also write a support function as below

public class MyPageBase : System.Web.UI.Page
{
    protected override void Render(HtmlTextWriter writer)
    {
         using (HtmlTextWriter htmlwriter = new HtmlTextWriter(new StringWriter()))
        {

            base.Render(htmlwriter);
            string html = htmlwriter.InnerWriter.ToString().Trim();

            if (ConfigurationManager.AppSettings["OptimizeHtmlOutput"] != "0")
            {
                bool isAsync = !html.StartsWith("<");

                if (!isAsync)
                {
                    StringBuilder sb = MyPageBase._TrimHtml(html);
                    writer.Write(sb.ToString());
                }
                else
                {
                    StringBuilder sb = new StringBuilder();

                    int startIx = 0;
                    while (true)
                    {
                        int x = html.IndexOf("|updatePanel|", startIx);

                        if (x > -1)
                        {
                            int xS = html.LastIndexOf("\r\n", x); xS = (xS < 0 ? 0 : xS);
                            int xE = html.IndexOf("\r\n", x) + 2;

                            string header = html.Substring(xS, xE - xS);
                            header = header.Trim().TrimStart('|', ' ');

                            string sLen = header.Substring(0, header.IndexOf('|'));
                            int cLen = int.Parse(sLen);

                            string content = html.Substring(xE - 2, cLen);
                            content = MyPageBase._TrimHtml(content).ToString().Trim();

                            startIx = xE - 2 + cLen;

                            cLen = content.Length + 4;
                            header = (xS > 0 ? "|" : string.Empty) + cLen.ToString() + header.Substring(header.IndexOf('|'));

                            sb.AppendLine(header);
                            sb.AppendLine(content);
                        }
                        else
                        {
                            string stateData = html.Substring(startIx);
                            sb.Append(stateData.Trim());

                            writer.Write(sb.ToString());
                            break;
                        }
                    }
                }
            }
            else
            {
                writer.Write(html);
            }
        }
    }

}

    private static StringBuilder _TrimHtml(string source)
    {
        StringBuilder sb = new StringBuilder();

        source = source.Trim();
        using (StringReader sr = new StringReader(source))
        {
            string data = string.Empty;
            while (data != null)
            {
                data = sr.ReadLine();
                if (data != null)
                {
                    data = data.TrimStart(' ', '\t');
                    if (data != string.Empty) sb.AppendLine(data);
                }
            }
        }

        return sb;
    }
}

Notes:
1. Notice the usage of ConfigurationManager.AppSettings["OptimizeHtmlOutput"] != "0". You can define a key in app settings section of the web.config file to enable or disable this feature. Any value other that “0” will enable the optimization.
2. This code works well in AJAX based applications as well.

Compare the size difference and performance by changing the flag. This is very beneficial especially in pages which contains a huge amount of data.

Multiple fileupload Control ..code $

kapiltapa — Wed, 25 Nov 2009 09:15:00 GMT

protected void btnUpload_Click(object sender, EventArgs e)
        {
            string imagepath;
            BLL.PhotosVideos.PhotosVideos objBLLPhotosVideos = new BLL.PhotosVideos.PhotosVideos();
            BEL.PhotosVideos.PhotosVideos objDALPhotosVideos = new BEL.PhotosVideos.PhotosVideos();

            HttpFileCollection FileUpload = Request.Files;
            for (int i = 0; i < FileUpload.Count; i++)
            {
                HttpPostedFile userPostedFile = FileUpload[i];
                if (userPostedFile.ContentLength > 0)
                {
                    string imagename = FileUpload[i].FileName;
                    string dirpath = System.Web.HttpContext.Current.Server.MapPath("\\Photos\\" + userid + "\\" + albumid.ToString());
                    DirectoryInfo drinfo = new DirectoryInfo("" + dirpath + "");
                    if (!drinfo.Exists)
                    {
                        drinfo.Create();
                    }
                    string imagepath1 = imagename.Replace("\\", "/");
                    string[] imagepath2 = imagepath1.Split('/');
                    int count = imagepath2.Length;
                    string imagepath3 = imagepath2[count - 1];
                    imagepath = dirpath + "\\" + Path.GetFileName(userPostedFile.FileName);
                    userPostedFile.SaveAs(imagepath);
                    objDALPhotosVideos.ALBUM_ID = Convert.ToInt32(albumid);
                    objDALPhotosVideos.SCRAP_ID = 0;
                    objDALPhotosVideos.EVENT_ID = 0;
                    objDALPhotosVideos.PHOTO_PATH = "~/Photos/Communities/" + userid + "/" + albumid + "/" + imagepath3;
                    objDALPhotosVideos.VIDEO_PATH = "";
                    objDALPhotosVideos.CREATED_BY = userid;

                    objBLLPhotosVideos.InsertImageWithAlbumId(objDALPhotosVideos);
                    BindDataTogvPhotos();

                }
                if (userPostedFile.ContentLength > 0)
                {

                    lblUpload.Text = "Photos Uploaded Successfully";
                    lblUpload.Visible = true;
                }
                //else
                //{
                //    //lblUpload.CssClass = "fail";
                //    //lblUpload.Text = "Please Select Photo";
                //    //lblUpload.Visible = true;
                //}

            }

        }

what are the new features avalable in .NET 3.5 ?

webwalker2k — Wed, 25 Nov 2009 02:30:54 GMT

Hi all,

In order to learn .NET 3.5 new features such as object initializers, lambda expressions, estension methods, anonymous classes and LINQ ... watch the FREE video below created by Software Training Academy (http://www.SoftwareTrainingAcademy.com)

http://www.softwaretrainingacademy.com/WB_VS2008_NF_MS2109.aspx

should you have any question .. email marc.bueno@SoftwareTrainingAcademy.com

LINQ, Extension Methods, Object Initializers and more

webwalker2k — Wed, 25 Nov 2009 02:40:22 GMT

Free video demonstrating .NET 3.5 new Features.

http://www.softwaretrainingacademy.com/WB_VS2008_NF_MS2109.aspx

Start the browser without toolbars (workaround)

Vournelis — Sun, 02 Aug 2009 16:38:17 GMT

Hello everybody, after spending the better part of the day yesterday searching through the forums I believe I put together a solution for starting your ASP.NET application without the address bar, toolbars, etc.

There are many discussions about this in forums.asp.net but i could not find one that would give a clear answer so I decided to write this post and maybe I can save some time for the next person looking for this solution.

The problem: I cannot adjust the browser to hide the toolbar, menubar, address bar... when it is launched by the user and I desperately need the vertical space while all the browser add ons are useless for my application.

Solution: Create a splash screen (a new web form) and enter the folowing script in the "Load_Complete" event sub.

ScriptManager.RegisterStartupScript(Me.Page, Me.GetType(), "Script", "<script language='javascript'>NewWin=window.open('UserLogin.aspx',null,'width=' + screen.width + ', height=' + screen.height + ', top=0, left=0, resizable=yes,menubar=no,toolbar=no,location=no,directories=no,status=no');window.open('','_self','');setTimeout('self.close();',5000);</script>", False)

Note: Where 'UserLogin.aspx' you should type the name of the form that you wish to have as startup form. You can also adjust the duration that the splash screen will stay on by changing the value in the setTimeout function. I think '5000' will do 5 seconds.

Now set the splash screen as your startup form and run it.

In this examble the browser will start with all the toolbars showing and it will display your splash screen. In the mean time it will open a new window without the toolbars and after waiting 5 seconds, it will close the window that the user launched (splash screen).

The problem was that without the statement window.open('','_self','');, Internet Explorer will prompt the user to confirm that the instance he/she launched is going to close.

This statement makes Internet Explorer think that the instance was launched through code and it closes without a message.

I would like to give credit to the programmer that posted the above statement on a forum but I went through so many forums that I could not find that post again. My apologies to the programmer.

Upload picture, resize and save in SQL database - THE ANSWER!

christian_danis — Sat, 10 Oct 2009 16:38:34 GMT

Hey guys and gals,

I have been looking for a solution for this all over the web and it took me a couple of hours to figure it out. Finally I did it. So, here's my code to upload a picture file using the fileupload control, resize the file and then store it to a SQL Server database.

        If FleUpload.HasFile Then
            Dim fileName As String = Server.HtmlEncode(FleUpload.FileName)
            Dim extension As String = System.IO.Path.GetExtension(fileName)
            If (extension.ToUpper = ".JPG") Or (extension.ToUpper = ".GIF") Then

                '**** Resize image section ****
                Dim image_file As System.Drawing.Image = System.Drawing.Image.FromStream(FleUpload.PostedFile.InputStream)
                Dim image_height As Integer = image_file.Height
                Dim image_width As Integer = image_file.Width
                Dim max_height As Integer = 120
                Dim max_width As Integer = 160


                image_height = (image_height * max_width) / image_width
                image_width = max_width

                If image_height > max_height Then
                    image_width = (image_width * max_height) / image_height
                    image_height = max_height
                Else
                End If


                Dim bitmap_file As New Bitmap(image_file, image_width, image_height)
                Dim stream As New System.IO.MemoryStream

                bitmap_file.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg)
                stream.Position = 0

                Dim data(stream.Length) As Byte
                stream.Read(data, 0, stream.Length)
                '**** End resize image section ****


                Dim myConn As New SqlConnection(ConfigurationManager.ConnectionStrings("cs").ConnectionString)
                Dim mycmd As New SqlCommand("se_equipmentimages_insert", myConn)
                mycmd.CommandType = CommandType.StoredProcedure

                mycmd.Parameters.AddWithValue("@equipment_id", id)
                mycmd.Parameters.AddWithValue("@image_file", data)

                Try
                    myConn.Open()
                    mycmd.ExecuteNonQuery()
                Catch ex As Exception
                Finally
                    myConn.Close()
                End Try

            Else
                lblError.Text = "Please only upload .jpg or .gif files"
                lblError.Visible = True
            End If
        Else
            lblError.Text = "No file selected"
            lblError.Visible = True
        End If

I hope this helps someone!

[Tip] Easily change image path for cute editor

Ritushido — Sat, 14 Nov 2009 16:32:16 GMT

Hi guys,

This could seem obvious for most and maybe there is a better solution but I couldn't find one so I made up my own solution and would like to share it with any other asp.net newbies such as myself.

Anyway if you've used Cute Editor in your apps you might notice that when a user uploads a file it goes to the /uploads/ folder in the root of your app, well my cms app is seperated from the website so I needed to change that filepath otherwise it would show in the cms app but not on the website. Well basically my cms contains a page title and a body and the user can edit the page body in the cms app so in my seperate application (the user's website) when I called the body text from the DB I would use a replace command to change the /uploads/ to the full path of the cms app. After testing this is worked like a charm and I was well chuffed that I actually solved something on my own! Below is an example:

 <asp:Literal ID="articleBody" Text='<%# Eval("PageBody").ToString().Replace("/uploads/", "http://cms.yourdomain.com/uploads/") %>' runat="server" />

That's basically it, now you will see the images on your seperate website application!

Sorry if this seems very simple but I spent ages trying to figure this out and thought I'd share it, happy to answer any questions!

Trick: Prevent user from navigating to a different tab in Panel client ClickEvent

urstop — Fri, 13 Nov 2009 21:00:08 GMT

Today I was working with the Tab Container control from Ajax tool kit and I had this requirement of preventing the user from navigating off to a different tab without completing the required fields on the active tab he was in. There is no direct feature in the toolkit that provides this feature. Googling around did not help me much. So, I sat down to write it. And here is code that I came up with that helps us to achive this feature. Not sure if this is the right way, but it does the job.

var ref_set_activeTab = null;
    var canChangeTab = false;
    function PanelClicked(sender, e)
    {
        var ctrl = sender.get_owner();
        if(ref_set_activeTab == null)
            ref_set_activeTab =  ctrl.set_activeTab;
        canChangeTab = doYourValidations();
        if(canChangeTab)
            ctrl.set_activeTab = ref_set_activeTab;
        else
            ctrl.set_activeTab = function(obj){};
        
    }

Debuging asp: can't find dllhost

pedrogameiropinto — Wed, 11 Nov 2009 15:25:45 GMT

Hello,

I wasn't finding the process dllhost to attach to in the Visual Studio Debug --> Processes tray. After some research I found the problem: In IIS site properties --> Home Directory --> Application Protection was set to low and when this happens dllhost becomes inetinfo. So I did put Application Protection to medium, did iisreset and voila... when I open the Debug --> Processes tray in VS there it it the dllhost to attach to.

Thanks to this good blog post: http://blogs.msdn.com/mikhailarkhipov/archive/2006/02/07/527293.aspx

Useful RSS feeds for .NET developers

studotnet — Sun, 04 Jan 2009 14:15:00 GMT

RSS feeds are very very useful.

Here are some feeds I use. Share your feeds also. That will help some other developers also.

ASP.NET News: http://www.asp.net/news/rss.ashx

ASP.NET Daily Articles: http://www.asp.net/community/articles/rss.ashx

ASP.NET Videos: http://www.asp.net/learn/videos/rss.ashx

Latest Microsoft Blogs: http://weblogs.asp.net/aspnet-team/rss.aspx

Learn ASP.NET - Latest Content: http://www.asp.net/learn/rss.ashx

MSDN Online Media Blog: http://blogs.msdn.com/msdnwebcasts/rss.xml

MSDN SQL Server Headlines: http://www.microsoft.com/feeds/msdn/en-us/sql/sqldev_en_us.xml

MSDN Code Gallery: http://code.msdn.microsoft.com/rss.ashx

C# Future: http://code.msdn.microsoft.com/csharpfuture/Project/ProjectRss.aspx

Channel 9: http://channel9.msdn.com/Feeds/RSS/

Free Microsoft E-Learning resources: http://learning.microsoft.com/rss/en-US/free?brand=Learning

CodePlex: http://www.codeplex.com/rss.ashx

The Code Project Latest Articles: http://www.codeproject.com/webservices/articlerss.aspx?cat=8

patterns & practices – Enterprise Library: http://www.codeplex.com/entlib/Project/ProjectRss.aspx

CodeBetter.Com: http://feeds.feedburner.com/CodeBetter

"How Do I?" Videos: http://www.microsoft.com/feeds/msdn/en-us/HDI/Home-HDI.xml

ScottGu's Blog: http://weblogs.asp.net/scottgu/rss.aspx

David Haydn http://feeds.feedburner.com/PnPGuidance

J.D. Meier's Blog: http://blogs.msdn.com/jmeier/rss.xml

ASP.NET MVC: http://feeds.feedburner.com/wekeroad/EeKc

ASP.Net, C#, SQL: http://feeds.feedburner.com/DotnetGuts

ASPAlliance.com: http://aspalliance.com/rss.aspx

ASPAlliance.com: http://aspalliance.com/videos/rss.aspx

A Solution for (Not-) CollapsiblePanelExtender Problems

Bearseeker — Mon, 09 Nov 2009 17:00:47 GMT

After 4 hours of intensive working on a collapsible panel extender with a "bubble" problem (click collapse: it collapse.. but at the end of animation it return at the original size), we find a solution for this: the bug is the value of property CollapsedSize. If it's set to 0 or -1, don't work; if it's set to 1 or more, it works.

It happened on a project over ASP.NET 2.0, with Ajax Control Toolkit 1.0.

Good work, people, and sorry for my poor english ;)

Davide
(Italy)

ASP.NET & RAW AJAX - chapter-2

thirumaran007 — Thu, 05 Nov 2009 11:59:59 GMT

This is second article .. from

ASP.NET & RAW AJAX

Chapter 2 : how to handle raw ajax from asp.net

Step 1 .create new web site solution from visual studio 2008/2005/2003

Step 2. Add new aspx page (Default.aspx)

Step 3. Add new ashx file (Callback.aspx)

Client side code

Write the following inline code on the Default.aspx page

<html>

<body>



    <script type="text/javascript">

function ajaxFunction(_requestname)

{

var xmlhttp;

if (window.XMLHttpRequest)

  {

  // code for IE7+, Firefox, Chrome, Opera, Safari

  xmlhttp=new XMLHttpRequest();

  }

else

  {

  // code for IE6, IE5

  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");

  }

xmlhttp.onreadystatechange=function()

{

if(xmlhttp.readyState==4)

  {

  if(xmlhttp.status==200)

   document.getElementById('lblResult').innerHTML =xmlhttp.responseText;

  }

}

var vMyName=document.getElementById('txtName').value

xmlhttp.open("GET","callback.ashx?requestname="+_requestname+"&name="+vMyName,true);

xmlhttp.send(null);

}

    </script>



    <form name="myForm">

    Name<input type="text" value="thirumaran" id="txtName" />

    <input type="button" id="btnRequest" onclick="ajaxFunction('yourname');" value="MyName" />

    <input type="button" id="Button1" onclick="ajaxFunction('yourfriendname');" value="MyFriendName" />

    <label id="lblResult">

    </label>

    </form>

</body>

</html>

Here the JavaScript function ajaxFunction – is used to create new Request to the server.

var xmlhttp;

if (window.XMLHttpRequest)

  {

  // code for IE7+, Firefox, Chrome, Opera, Safari

  xmlhttp=new XMLHttpRequest();

  }

else

  {

  // code for IE6, IE5

  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");

  }

-These lines is used to create new Instance of XMLHTTp object.i hope that you are aware of the XML http request usage. For more details please go through the folloing link.

http://forums.asp.net/t/1489223.aspx

after getting the response or result the following line will be call

xmlhttp.onreadystatechange=function()

{

if(xmlhttp.readyState==4)

  {

  if(xmlhttp.status==200)

   document.getElementById('lblResult').innerHTML =xmlhttp.responseText;

  }

}

Here the xmlhttp.readyState=4 means our page request is compleate and redy to get the result or reponse

Some more ready state codes are there please refre the following table

State	Description
0	The request is not initialized
1	The request has been set up
2	The request has been sent
3	The request is in process
4	The request is complete

And xmlhttp.status=200 – means our request is successfully ok without eny erorr and response is ready to getting result.

document.getElementById('lblResult').innerHTML =xmlhttp.responseText;

-here I have to add the response result ( result text) to a lables which name is blresult.this way you can apply the result any other basic javascript Html control.

And

var vMyName=document.getElementById('txtName').value

xmlhttp.open("GET","callback.ashx?requestname="+_requestname+"&name="+vMyName,true);

xmlhttp.send(null);

these code is used to make call the the server (callback.ashx?) with nessay paramter like request name and your input value like that

and finely the xmlhttp rquest will send the the server .here the server meadns callback.asphs file.this files will exuecute in server(IIS server)

Server side code

Write the following inline code on the callback.ashx page

<%@ WebHandler Language="C#" %>



using System;

using System.Web;



public class callback : IHttpHandler

{

    HttpContext _context;

    public void ProcessRequest(HttpContext context)

    {

        _context = context;

        context.Response.Expires = 0;

        CallBackHandler();



    }

    private void CallBackHandler()

    {

        try

        {

            _context.Response.Clear();

            _context.Response.Expires = 0;

            _context.Response.ExpiresAbsolute = DateTime.Now;

            _context.Response.Write(fnResultBuilder());

        }

        catch (Exception)

        {



            throw;

        }



    }

    private string fnResultBuilder()

    {

        string strRquestName = _context.Request.QueryString["requestname"];

        string strReturnValue = "";

        switch (strRquestName)

        {

            case "yourname":

                strReturnValue = "your Name is " + _context.Request.QueryString["name"].ToString();

                break;

            case "yourfriendname":

                strReturnValue = "your Friend Name is " + _context.Request.QueryString["name"].ToString();

                break;



        }

        return strReturnValue;

    }

    public bool IsReusable

    {

        get

        {

            return false;

        }

    }





}

The following function is entry point of our request

HttpContext _context;

    public void ProcessRequest(HttpContext context)

    {

        _context = context;

        context.Response.Expires = 0;

        CallBackHandler();



    }

Here I have called the user defined function CallBackHandler() to get the result

Inside the callback handler I have get the result from the fnResultBuilder function .this function will ge the request informatin about what kind of request is this and what should the function too like that information are availble on that function

_context.Response.Write(fnResultBuilder());

And the finally

string strRquestName = _context.Request.QueryString["requestname"];

This line indicates the kind of response is this and what is request name like that.

If the request name is “yourname” then the folloing line will execute and give the response as response .write method

case "yourname":

strReturnValue = "your Name is " + _context.Request.QueryString["name"].ToString();

break;

That’s all from the second chapter kindly revert me is the any clarifications.

I hope that this article is very simple one and very useful…

Will see in third chapter with interesting topic,.

Thanks & regards

Thirumaran.S

System.Drawing.Color Reference

koushik.dhar — Fri, 06 Nov 2009 14:11:54 GMT

This shows all the available color names in the System.Drawing.Color structure, along with an example of what that color looks like in your browser.

As ever there are complications. What it looks like in your browser is not necessarily the same as it will look in an application, or in a different browser, or on a different operating system, or on a different monitor. Best to regard this as a ‘handy guide’ rather than a definitive comparison chart.

AliceBlue	Hex Code: #F0F8FF
AntiqueWhite	Hex Code: #FAEBD7
Aqua	Hex Code: #00FFFF
Aquamarine	Hex Code: #7FFFD4
Azure	Hex Code: #F0FFFF
Beige	Hex Code: #F5F5DC
Bisque	Hex Code: #FFE4C4
Black	Hex Code: #000000
BlanchedAlmond	Hex Code: #FFEBCD
Blue	Hex Code: #0000FF
BlueViolet	Hex Code: #8A2BE2
Brown	Hex Code: #A52A2A
BurlyWood	Hex Code: #DEB887
CadetBlue	Hex Code: #5F9EA0
Chartreuse	Hex Code: #7FFF00
Chocolate	Hex Code: #D2691E
Coral	Hex Code: #FF7F50
CornflowerBlue	Hex Code: #6495ED
Cornsilk	Hex Code: #FFF8DC
Crimson	Hex Code: #DC143C
Cyan	Hex Code: #00FFFF
DarkBlue	Hex Code: #00008B
DarkCyan	Hex Code: #008B8B
DarkGoldenrod	Hex Code: #B8860B
DarkGray	Hex Code: #A9A9A9
DarkGreen	Hex Code: #006400
DarkKhaki	Hex Code: #BDB76B
DarkMagenta	Hex Code: #8B008B
DarkOliveGreen	Hex Code: #556B2F
DarkOrange	Hex Code: #FF8C00
DarkOrchid	Hex Code: #9932CC
DarkRed	Hex Code: #8B0000
DarkSalmon	Hex Code: #E9967A
DarkSeaGreen	Hex Code: #8FBC8B
DarkSlateBlue	Hex Code: #483D8B
DarkSlateGray	Hex Code: #2F4F4F
DarkTurquoise	Hex Code: #00CED1
DarkViolet	Hex Code: #9400D3
DeepPink	Hex Code: #FF1493
DeepSkyBlue	Hex Code: #00BFFF
DimGray	Hex Code: #696969
DodgerBlue	Hex Code: #1E90FF
Firebrick	Hex Code: #B22222
FloralWhite	Hex Code: #FFFAF0
ForestGreen	Hex Code: #228B22
Fuchsia	Hex Code: #FF00FF
Gainsboro	Hex Code: #DCDCDC
GhostWhite	Hex Code: #F8F8FF
Gold	Hex Code: #FFD700
Goldenrod	Hex Code: #DAA520
Gray	Hex Code: #808080
Green	Hex Code: #008000
GreenYellow	Hex Code: #ADFF2F
Honeydew	Hex Code: #F0FFF0
HotPink	Hex Code: #FF69B4
IndianRed	Hex Code: #CD5C5C
Indigo	Hex Code: #4B0082
Ivory	Hex Code: #FFFFF0
Khaki	Hex Code: #F0E68C
Lavender	Hex Code: #E6E6FA
LavenderBlush	Hex Code: #FFF0F5
LawnGreen	Hex Code: #7CFC00
LemonChiffon	Hex Code: #FFFACD
LightBlue	Hex Code: #ADD8E6
LightCoral	Hex Code: #F08080
LightCyan	Hex Code: #E0FFFF
LightGoldenrodYellow	Hex Code: #FAFAD2
LightGray	Hex Code: #D3D3D3
LightGreen	Hex Code: #90EE90
LightPink	Hex Code: #FFB6C1
LightSalmon	Hex Code: #FFA07A
LightSeaGreen	Hex Code: #20B2AA
LightSkyBlue	Hex Code: #87CEFA
LightSlateGray	Hex Code: #778899
LightSteelBlue	Hex Code: #B0C4DE
LightYellow	Hex Code: #FFFFE0
Lime	Hex Code: #00FF00
LimeGreen	Hex Code: #32CD32
Linen	Hex Code: #FAF0E6
Magenta	Hex Code: #FF00FF
Maroon	Hex Code: #800000
MediumAquamarine	Hex Code: #66CDAA
MediumBlue	Hex Code: #0000CD
MediumOrchid	Hex Code: #BA55D3
MediumPurple	Hex Code: #9370DB
MediumSeaGreen	Hex Code: #3CB371
MediumSlateBlue	Hex Code: #7B68EE
MediumSpringGreen	Hex Code: #00FA9A
MediumTurquoise	Hex Code: #48D1CC
MediumVioletRed	Hex Code: #C71585
MidnightBlue	Hex Code: #191970
MintCream	Hex Code: #F5FFFA
MistyRose	Hex Code: #FFE4E1
Moccasin	Hex Code: #FFE4B5
NavajoWhite	Hex Code: #FFDEAD
Navy	Hex Code: #000080
OldLace	Hex Code: #FDF5E6
Olive	Hex Code: #808000
OliveDrab	Hex Code: #6B8E23
Orange	Hex Code: #FFA500
OrangeRed	Hex Code: #FF4500
Orchid	Hex Code: #DA70D6
PaleGoldenrod	Hex Code: #EEE8AA
PaleGreen	Hex Code: #98FB98
PaleTurquoise	Hex Code: #AFEEEE
PaleVioletRed	Hex Code: #DB7093
PapayaWhip	Hex Code: #FFEFD5
PeachPuff	Hex Code: #FFDAB9
Peru	Hex Code: #CD853F
Pink	Hex Code: #FFC0CB
Plum	Hex Code: #DDA0DD
PowderBlue	Hex Code: #B0E0E6
Purple	Hex Code: #800080
Red	Hex Code: #FF0000
RosyBrown	Hex Code: #BC8F8F
RoyalBlue	Hex Code: #4169E1
SaddleBrown	Hex Code: #8B4513
Salmon	Hex Code: #FA8072
SandyBrown	Hex Code: #F4A460
SeaGreen	Hex Code: #2E8B57
SeaShell	Hex Code: #FFF5EE
Sienna	Hex Code: #A0522D
Silver	Hex Code: #C0C0C0
SkyBlue	Hex Code: #87CEEB
SlateBlue	Hex Code: #6A5ACD
SlateGray	Hex Code: #708090
Snow	Hex Code: #FFFAFA
SpringGreen	Hex Code: #00FF7F
SteelBlue	Hex Code: #4682B4
Tan	Hex Code: #D2B48C
Teal	Hex Code: #008080
Thistle	Hex Code: #D8BFD8
Tomato	Hex Code: #FF6347
Transparent	Hex Code: #FFFFFF
Turquoise	Hex Code: #40E0D0
Violet	Hex Code: #EE82EE
Wheat	Hex Code: #F5DEB3
White	Hex Code: #FFFFFF
WhiteSmoke	Hex Code: #F5F5F5
Yellow	Hex Code: #FFFF00
YellowGreen	Hex Code: #9ACD32

A simple way to add some flair to your site with a favicon

rtpHarry — Sat, 24 Oct 2009 20:27:24 GMT

Not a strictly asp.net related topic today but certainly useful to know when you develop your next website.

I take a day out from asp.net topics to explain how you can get the little icon that appears next to the url in the address bar on many of your favourite sites. You will also find it next to its name if you add it to your favourites.

Yep its the favicon, a staple of every major website but not a topic that you will get introduced to if you are strictly reading dev sites.

http://runtingsproper.blogspot.com/2009/10/simple-way-to-add-some-flair-to-your.html

ASP.NET & RAW AJAX - Chapters

thirumaran007 — Thu, 05 Nov 2009 07:19:44 GMT

From this topic " ASP.NET & RAW AJAX "- we will learn how to use RAW ajax in our asp.net appliaton , what is the use of ashx file and how to implement ajax with out ActiveX..like so many intresting topics will cover. in first cahpter we descrips the use of XML http request object

Chapeter 1: About XMLHTTPREQUEST

XMLHttp Request object for Ajax

XMLHttp is an powerfull object for create RAW ajax based application.genrally ajax is not new technology it is already existing some javascript techniqu.

condider the XMLHTTP is new Broweser.when we call the XMLHttp object in your applicaton ...it will create new webbrowser in our application (virtualy) then we can get the result from the web brower in place it

in our original browser.

The first step that we have to learn in AJAX is the XMLHTTP request. This we will be using in every Ajax code we write. A good understanding of this will help us in analyzing and developing complex codes.

An agent or a broker

This XMLHttp object is an agent between our application at client side and our programming code at server end. It sends data and collects the return data from the server.

Now we understood that creation of this XMLHttp request is an issue with the browser of the user ( or client ). So the user browser must able to create this XMLHttp object. Unfortunately the old browsers doest not support this and can't create XMLHttp object. So we have to find out first this object is created or not. If the browser fails to create the object then we must give error message saying about the browser issue.

Even if the browser are capable of creating our XMLHttp request they differ in the way they create it. FireFox create the object in a different way than Internet Explorer ( IE ). So based on this we will develop the code and note that we can use this same set of code ( to create the XMLHttp object ) in all pages where we will be using Ajax. Let us develop the code.

We will try with first trying with a simple request like this

if (typeof XMLHttpRequest != "undefined")

The above line will return true for Firfox and Safari so we can create an object. For IE we will use ActiveXObject to create the object. Depending on the type of ActiveXObject support which depends on version of IE we will create the object. If in all fail in crating the object then we will return error message.

Now let us write the function to initialize the HMLHttp Request object

function developXMLHttp() {

if (typeof XMLHttpRequest != "undefined") {

return new XMLHttpRequest();

} else if (window.ActiveXObject) {

var aVersions = [ "MSXML2.XMLHttp.5.0",

"MSXML2.XMLHttp.4.0","MSXML2.XMLHttp.3.0",

"MSXML2.XMLHttp","Microsoft.XMLHttp"

];

for (var x = 0; x < aVersions.length; x++) {

try {

var p2XmlHttp = new ActiveXObject(aVersions[x]);

return p2XmlHttp;

} catch (oError) {

//Do nothing

}

}

}

throw new Error("Error..XMLHttp object could be created.");

}

//To use this function we will create an object like this.

function my_form(){

var myxml=developXMLHttp();

document.write(typeof(myxml));

}

window.onload=my_form();

Learn exactly how you can restore a .bak file in SQL Management Studio with this step-by-step guide

rtpHarry — Sat, 31 Oct 2009 13:54:01 GMT

Read a step by step guide which will show you how to restore a .bak file in Microsoft SQL Server Management Studio. This technique can be used to move databases between servers or restore an existing database to a previous state:

http://runtingsproper.blogspot.com/2009/10/learn-exactly-how-you-can-restore-bak.html

Moving data from MS Access to MySQL is easy

mysorian — Sat, 11 Jul 2009 03:55:05 GMT

Review the following article :

http://hodentek.blogspot.com/2009/07/taking-table-over-to-mysql-from-ms.html

Google Maps via ASP.NET / SQL Server Tutorial

antonyvijayan — Tue, 08 Jul 2008 10:53:11 GMT

Hi,

I worked out for google map with ASP.Net / VB.Net. below steps you have to follow,

1. You need to get encrpyted key from google which key for your own website.

2. create a table as below,

          if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[map]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
            drop table [dbo].[map]
          GO

           CREATE TABLE [dbo].[map] (
           [id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
          [lat] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
          [lon] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
         [description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
         [cid] [numeric](18, 0) NOT NULL ---cid meant centerID
         ) ON [PRIMARY]
        GO

3. Copy below code for map_test.aspx page

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Map_test.aspx.vb" Inherits="Map_test" %>

<% Response.Write(maptest())%>

4. Below code for map_test.aspx.vb

Public Function maptest() As String

Dim strmap As String = ""

' Dim strMap As String = ""

Dim strMap1 As String = ""

Dim drResult As SqlDataReader

Dim SQLResult As String = ""

Dim strLon As String = ""

Dim strLat As String = ""

Try

strmap = strmap + " <!DOCTYPE html PUBLIC """"-//W3C//DTD XHTML 1.0 Strict//EN"""" """"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"">"

strmap = strmap + " <html xmlns=""http://www.w3.org/1999/xhtml"">"

strmap = strmap + " <head>"

strmap = strmap + " <meta http-equiv=""content-type"" content=""google maps via ASP.Net : text/html; charset=utf-8""/>"

strmap = strmap + " <title>Google Maps JavaScript API Example</title>"

strmap = strmap + " <script src=""http://maps.google.com/maps?file=api&v=2&key=ABQIAAAAXu6-xqCzQg7UF16n1xbPlxRy0V4Q1dfyNo3tEYtAttAGexdRsBSFtycVVZx_tF4NT4Xrn_SOyBa6pQ"""

strmap = strmap + " type=""text/javascript""></script>"

strmap = strmap + " <script type=""text/javascript"">"

'strmap = strmap + " //<![CDATA["

'strmap = strmap + " // Creates a marker whose info window displays the given number"

strmap = strmap + " function createMarker(point, number)"

strmap = strmap + " {"

strmap = strmap + " var marker = new GMarker(point);"

'strmap = strmap + " // Show this markers index in the info window when it is clicked"

strmap = strmap + " var html = number;"

strmap = strmap + " GEvent.addListener(marker, ""click"", function() {marker.openInfoWindowHtml(html);});"

strmap = strmap + " return marker;"

strmap = strmap + " };"

strmap = strmap + " function load() {"

strmap = strmap + " if (GBrowserIsCompatible()) {"

strmap = strmap + " var map = new GMap2(document.getElementById(""map""));"

strmap = strmap + " map.addControl(new GLargeMapControl());"

strmap = strmap + " map.addControl(new GMapTypeControl());"

strmap = strmap + " map.addControl(new GScaleControl());"

Dim blnPoint As Boolean = False

clsSearch.ConnectionString() ' calling connectionstring function

SQLResult = "Select * from map where cid=12" ' i just hard code for center id.

drResult = SqlHelper.ExecuteReader(clsSearch.t_IncidentStr, CommandType.Text, SQLResult) ' executing sql query by using sql helper class

If drResult.HasRows Then

While drResult.Read

If blnPoint = False Then

strmap = strmap + " map.setCenter(new GLatLng(" & drResult("lat").ToString & "," & drResult("lon").ToString & "), 13);"

blnPoint = True

End If

If Not IsDBNull(drResult("lon")) Then

strLon = drResult("lon").ToString

End If

If Not IsDBNull(drResult("lat")) Then

strLat = drResult("lat").ToString

End If

strmap = strmap + "var point = new GLatLng(" & drResult("lat").ToString & "," & drResult("lon").ToString & ");"

strmap = strmap + " var marker = createMarker(point,'" & drResult("lat").ToString & "');"

strmap = strmap + "map.addOverlay(marker);"

End While

End If

strmap = strmap + " }"

' strmap = strmap + " //]]>"

strmap = strmap + " </script>"

strmap = strmap + " </head>"

strmap = strmap + " <body onload=""load()"" onunload=""GUnload()"">"

strmap = strmap + " <div id=""map"" style=""width: 1200px; height: 600px""></div>"

strmap = strmap + " </body>"

strmap = strmap + " </html>"

Catch ex As Exception

End Try

Return strmap

End Function

Please free to ask your queries and if this code is useful for you, kindly post response.

thank you.