what is wizard control in asp.net

The Wizard control is a complex control that is used to display a series of Wizard Step
controls to a user, one after the other, as part of a user input process.

The built-in navigation capabilities determine which buttons are displayed based on the
Step Type value. The Base Wizard Step class contains the Step Type property that can be set to
one of the following values:

Wizard Step Type. Auto
This renders navigation buttons based on the location of the set within the Wizard Steps collection property of the Wizard. This is the default.

Wizard Step Type. Complete 
This is the last step to appear. No navigation buttons are rendered.

Wizard Step Type .Finish 
This is the final data collection step; the Finish and Previous buttons are rendered for navigation.

Wizard Step Type. Start 
This is the first one to appear, and only the Next button is rendered.

Wizard Step Type. Step 
This is a step between the Start and the Finish steps.The Previous and Next buttons are rendered.

<asp:Wizard ID="Wizard1" runat="server" ActiveStepIndex="4" OnFinishButtonClick="Wizard1_FinishButtonClick" BorderColor="Black" BorderStyle="Solid">

                <WizardSteps>

                    <asp:WizardStep runat="server" Title="Step 1">

                        welcome to wizard control

                    </asp:WizardStep>

                    <asp:WizardStep runat="server" Title="Step 2">

                        Enter first name<br />

                        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

                    </asp:WizardStep>

                    <asp:WizardStep runat="server" Title="Step 3">

                        Enter Last Name<br />

                        <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>

                    </asp:WizardStep>

                    <asp:WizardStep runat="server" Title="Step 4">

                        Enter Hobbies<br />

                        <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>

                    </asp:WizardStep>

                    <asp:WizardStep runat="server" Title="Step 5">

                        You are complite

                    </asp:WizardStep>

                </WizardSteps>

            </asp:Wizard>

    protected void Wizard1_FinishButtonClick(object sender, WizardNavigationEventArgs e)

    {

        Response.Write(TextBox1.Text);

    }

how to display Advertisement in AdRotator in asp.net

create .xml file and add code like below

<Advertisements>

   <Ad>

      <ImageUrl>rose1.jpg</ImageUrl>

      <NavigateUrl>http://www.1800flowers.com</NavigateUrl>

      <AlternateText>

         Order flowers, roses, gifts and more

      </AlternateText>

      <Impressions>20</Impressions>

      <Keyword>flowers</Keyword>

   </Ad>

   <Ad>

      <ImageUrl>rose2.jpg</ImageUrl>

      <NavigateUrl>http://www.babybouquets.com.au</NavigateUrl>

      <AlternateText>Order roses and flowers</AlternateText>

      <Impressions>20</Impressions>

      <Keyword>gifts</Keyword>

   </Ad>

   <Ad>

      <ImageUrl>rose3.jpg</ImageUrl>

      <NavigateUrl>http://www.flowers2moscow.com</NavigateUrl>

      <AlternateText>Send flowers to Russia</AlternateText>

      <Impressions>20</Impressions>

      <Keyword>russia</Keyword>

   </Ad>

   <Ad>

      <ImageUrl>rose4.jpg</ImageUrl>

      <NavigateUrl>http://www.edibleblooms.com</NavigateUrl>

      <AlternateText>Edible Blooms</AlternateText>

      <Impressions>20</Impressions>

      <Keyword>gifts</Keyword>

   </Ad>

</Advertisements>

take adrotator control from toolbox in .aspx file

<asp:AdRotator ID="AdRotator1" runat="server" AdvertisementFile="~/XMLFile.xml" Height="200px" Width="200px" />

store image in database with image type and read image from database and display in gridview

.aspx file

        name<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

        <br />

        imagef<asp:FileUpload ID="FileUpload1" runat="server" />

        <br />

        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />

        <br />

        <br />

        <br />

       

        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False">

            <Columns>

                <asp:TemplateField>

                    <ItemTemplate>

                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("id") %>'></asp:Label>

                    </ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField>

                    <ItemTemplate>

                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("name") %>'></asp:Label>

                    </ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField>

                    <ItemTemplate>

                        <a href='<%# string.Concat("/DisplayImg.ashx?id=", Eval("id"))%>' download='<%# string.Concat("",Eval("name")) %>'>

                        <asp:Image ID="Image1" runat="server" Height="46px" Width="97px" ImageUrl='<%# string.Concat("~/DisplayImg.ashx?id=", Eval("id"))%>'/>

                            </a>

                    </ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="Download">

                    <ItemTemplate>

                        <a href='<%# string.Concat("/DisplayImg.ashx?id=", Eval("id"))%>' download="file">Download</a>

                    </ItemTemplate>

                </asp:TemplateField>

            </Columns>

        </asp:GridView>

.aspx.cs

BAL b = new BAL();

protected void Page_Load(object sender, EventArgs e)

    {

        GridView2.DataSource = b.bindempl();

        GridView2.DataBind();

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        Byte[] imgByte = null;

        if (FileUpload1.HasFile && FileUpload1.PostedFile != null)

        {

            HttpPostedFile File = FileUpload1.PostedFile;

            imgByte = new Byte[File.ContentLength];

            File.InputStream.Read(imgByte, 0, File.ContentLength);

            b.name = TextBox1.Text;

            b.imgbyte = imgByte;

            b.saveempl(b);

            GridView2.DataSource = b.bindempl();

            GridView2.DataBind();

        }

    }

DisplayImg.ashx

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

using System;

using System.Web;

using System.IO;

public class DisplayImg : IHttpHandler {

    BAL b = new BAL();

    public void ProcessRequest (HttpContext context)

    {

        Int32 theID;

        if (context.Request.QueryString["id"] != null)

            theID = Convert.ToInt32(context.Request.QueryString["id"]);

        else

            throw new ArgumentException("No parameter specified");

        context.Response.ContentType = "image/jpeg";

        Stream strm = b.DisplayImage(theID);

        byte[] buffer = new byte[2048];

        int byteSeq = strm.Read(buffer, 0, 2048);

        while (byteSeq > 0)

        {

            context.Response.OutputStream.Write(buffer, 0, byteSeq);

            byteSeq = strm.Read(buffer, 0, 2048);

        }

    }

    public bool IsReusable {

        get {

            return false;

        }

    }

}

BAL.cs

public class BAL:DAL

{

       public BAL()

       {

              //

              // TODO: Add constructor logic here

              //

       }

    //file in db

    public int id1 { get; set; }

    public string name { get; set; }

    public byte[] imgbyte { get; set; }

   

}

DAL.cs

public Stream DisplayImage(int theID)

    {

        string sql = "SELECT image FROM empl WHERE id = @ID";

        SqlCommand cmd = new SqlCommand(sql, con);

        cmd.CommandType = CommandType.Text;

        cmd.Parameters.AddWithValue("@ID", theID);

        con.Open();

        object theImg = cmd.ExecuteScalar();

        try

        {

            return new MemoryStream((byte[])theImg);

        }

        catch

        {

            return null;

        }

        finally

        {

            con.Close();

        }

    }

    public DataSet bindempl()

    {

        cmd = new SqlCommand("select * from empl", con);

        cmd.CommandType = CommandType.Text;

        da = new SqlDataAdapter(cmd);

        ds = new DataSet();

        da.Fill(ds);

        return ds;

    }