How To Alter image DataType to varchar?

it is not possible to convert image data type to varchar. To use image datatype column to as a string So you 
can Alter image to varBinary with some limitation.

Query

alter Table Tbl_Suppliers
alter column ProfileImage Varbinary 

Alter Coulmn Size in Sql

Alter Table [Tablename] Products
Alter [ColumnName] Tea   varchar(50)

Alter Coulmn Name in Sql

Alter table [TableName] Products
 Alter[CoulmName]  Tea  [Type]   varchar(100)

Xml Code not Worked in Blogger Post

Xml Converter Use This Link To Convert Xml Code

Asp Menu Control Not working in ie8

<div class="navi_link">

<asp:Menu ID="menuNavigator" runat="server" DisappearAfter="0" StaticSubMenuIndent="0px"
StaticEnableDefaultPopOutImage="False" DataSourceID="SiteMapDataSource2"
Orientation="Horizontal" StaticDisplayLevels="2"
ItemWrap="True" MaximumDynamicDisplayLevels="4" BorderWidth="0"
BorderStyle="None" Font-Size="16px">


<StaticMenuItemStyle Height="20px" ForeColor="Black"
VerticalPadding="0px" BorderWidth="0" BorderStyle="None" />
<DynamicMenuStyle CssClass="sum_menu" />

<Dynamicmenuitemstyle verticalpadding="0px" font-size="0px" BorderWidth="0" BorderStyle="None" />

<DynamicHoverStyle ForeColor="Blue" Font-Size="16px" />
<DynamicSelectedStyle HorizontalPadding="0px" BorderWidth="0" BorderStyle="None" />

</asp:Menu>
<asp:SiteMapDataSource ID="SiteMapDataSource2" runat="server" />

</div>

-----------------------------------------------------
Step2.
Now Go to Css Class
.sum_menu
{
z-index: 1;
}


------------------------------------------------------
Or Stilll not working So Then

Write this code in Head Tag of .aspx Page

<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />

Menu Control With SiteMapDataSource

Here is Code for Using Menu Control With SiteMapDataSOurce


Go TO Html Source
<div>
<asp:Menu ID="menuNavigator" runat="server" DisappearAfter="0" StaticSubMenuIndent="10px" StaticEnableDefaultPopOutImage="False" Orientation="Horizontal" StaticDisplayLevels="2" DataSourceID="SiteMapDataSource1" ItemWrap="True">
<DynamicMenuStyle Width="110px" HorizontalPadding="5px" />
</asp:Menu>
<asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" />
</div>


Now Add SiteMap File And Type This Code
<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
<siteMapNode>
<siteMapNode url="Parent.aspx" title="Organizations" description="">
<siteMapNode url="Child1.aspx" title="Organizations1" description="">
<siteMapNode url="SubCHild1.aspx" title="SubOrg1" description=""> </siteMapNode>
</siteMapNode>
<siteMapNode url="Child2.aspx" title="Organizations2" description="">
</siteMapNode>
</siteMapNode>
<siteMapNode url="Parent2.aspx" title="Insured" description="">
<siteMapNode url="Child21.aspx" title="Insured1" description=""> </siteMapNode>
<siteMapNode url="Child22.aspx" title="Insured2" description=""> </siteMapNode>
</siteMapNode>
<siteMapNode url="Parent3.aspx" title="Policies" description="">
<siteMapNode url="Child31.aspx" title="Preview" description=""></siteMapNode>
</siteMapNode>
<siteMapNode url="Parent4.aspx" title="Reporting" description="">
</siteMapNode>
<siteMapNode url="Parent5.aspx" title="Billing" description=""></siteMapNode>
</siteMapNode>
</siteMap>

Note:-This Code Only Use In ASP.NET

Menu Control

Menu Control With SiteMapDataSource

Here Is a small and easy tutorial for Menu Control With SiteMapDataSource

Html Source 

                        StaticEnableDefaultPopOutImage="False" Orientation="Horizontal" StaticDisplayLevels="1" DataSourceID="SiteMapDataSource2" ItemWrap="True">


                   


SiteMapFile:-

Add Site Map File From Add New Item

   
       
Here Is a small and easy tutorial for Menu Control With SiteMapDataSource

Html Source 

                        StaticEnableDefaultPopOutImage="False" Orientation="Horizontal" StaticDisplayLevels="1" DataSourceID="SiteMapDataSource2" ItemWrap="True">


                   

 
SiteMapFile:-

Add Site Map File From Add New Item

   
       
           
               
           
           
               
               
           
       
       
           
           
               
       
           
       
       
       
       
       
       


 

Note:-This Code Only Used In Asp.net






           
               
           
           
               
               
           
       
       
           
           
               
       
           
       
       
       
       
       
       

Note:-This Code Only Used In Asp.net

My Online Projects

 Here is a Link Of Website. I mean my office work.
Collage Management

Real State Work
Jobs Management
Shoping Card

Dear viewers Please Comment On these links

My First Post

hii this is my first blog.   In this blog you can see every queries ..and solution of these queries which are in your present mind

Thankss

Kapil.cssoft

My First Post

hii this is my first blog.   In this blog you can see every queries ..and solution of these queries which are in your present mind