fill drop down list from database

 private void Form1_Load(object sender, EventArgs e)
        {
            con.Open();

            SqlDataAdapter da = new SqlDataAdapter("select name from sample ", con);
            DataTable dt = new DataTable();
            da.Fill(dt);
            comboBox1.DataSource = dt ;
            comboBox1.ValueMember = "name";
            comboBox1.DisplayMember = "name";
            con.Close();

        }

retrieving data from database to lables

  private void button3_Click(object sender, EventArgs e)
        {
            con.Open();
            SqlCommand cmd9 = new SqlCommand("select * from sample", con);
            SqlDataReader dr = cmd9.ExecuteReader();
            while (dr.Read())
            {
                textBox3.Text = dr["name"].ToString();
                textBox4.Text = dr["email"].ToString();
            }
        }

Export Grid View to excel and word in asp

//Before pasting this code, In design you have one grid view(ex:gvdetails) and  two buttons(ex :btnWord, btnExcel)
using System;
using System.Configuration;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
public override void VerifyRenderingInServerForm(Control control)
{
/* Verifies that the control is rendered */
}

protected void btnWord_Click(object sender, ImageClickEventArgs e)
{
gvdetails.AllowPaging = false;
gvdetails.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.doc"));
Response.Charset = "";
Response.ContentType = "application/ms-word";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gvdetails.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
/// <summary>
/// This Event is used to export gridview data to Excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnExcel_Click(object sender, ImageClickEventArgs e)
{
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gvdetails.AllowPaging = false;
gvdetails.DataBind();
//Change the Header Row back to white color
gvdetails.HeaderRow.Style.Add("background-color", "#FFFFFF");
//Applying stlye to gridview header cells
for (int i = 0; i < gvdetails.HeaderRow.Cells.Count; i++)
{
gvdetails.HeaderRow.Cells[i].Style.Add("background-color", "#507CD1");
}
int j = 1;
//This loop is used to apply stlye to cells based on particular row
foreach (GridViewRow gvrow in gvdetails.Rows)
{
gvrow.BackColor = Color.White;
if (j <= gvdetails.Rows.Count)
{
if (j % 2 != 0)
{
for (int k = 0; k < gvrow.Cells.Count; k++)
{
gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");
}
}
}
j++;
}
gvdetails.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
   
 
}

slidshow

 Random r = new Random();
        int a = r.Next(1, 5);
        Image1.ImageUrl = "image/" + a.ToString() + ".jpg";



use a timer
and script manager
and place code in formload

windows form preview image

 DialogResult result = openFileDialog1.ShowDialog();
                       string s = openFileDialog1.FileName.ToString();
                       pictureBox1.ImageLocation= s;
           

popup

default.aspx
html code:
 <form id="form1" runat="server">
    <div>
     Focus to open a popup :
        <asp:TextBox ID="txtOpenPopup" runat="server" onkeydown="OpenPopup()" onmousedown="OpenPopup()" />
        <br />
        <br />
        <asp:FileUpload ID="FileUpload1" runat="server" />
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="pREVIEW" />
        <br />
        <br />
        <br />
        <asp:ImageButton ID="ImageButton1" runat="server"  onkeydown="OpenPopup()" onmousedown="OpenPopup()" Height="70px" ImageUrl="~/images/beauty (9).jpg" />
        <br />
        <script language="javascript">

            function OpenPopup() {

                popup("PopupPage.aspx");

            }
          
           
</script>
        <script>
    function popup(url) {

    var width = 600;

    var height = 400;

    var left = (screen.width - width) / 2;

    var top = (screen.height - height) / 2;

    var params = 'width=' + width + ', height=' + height;

    params += ', top=' + top + ', left=' + left;

    params += ', directories=no';

    params += ', location=no';

    params += ', menubar=no';

    params += ', resizable=no';

    params += ', scrollbars=no';

    params += ', status=no';

    params += ', toolbar=no';

    newwin = window.open(url, 'windowname5', params);

    if (window.focus) { newwin.focus() }

    return false;

}

</script>

    </div>
    </form>


button:

        FileUpload1.SaveAs(Server.MapPath("images/")+FileUpload1.FileName);
        string s = "images/" + FileUpload1.FileName;
        ImageButton1.ImageUrl=s;
        Session["a"] = s;

popup.aspx:
form load:
Image1.ImageUrl = Session["a"].ToString();

image preview mouse over

protected void Page_Load(object sender, EventArgs e)
    {
         ImageButton1.Attributes.Add("onmouseover", "ShowImage('NewFolder1/desert.jpg');");
         ImageButton1.Attributes.Add("onmouseout", "HideImage();");
 
    }



<body>
    <form id="form1" runat="server">
    <asp:ImageButton ID="ImageButton1" ImageUrl ="~/NewFolder1/Lighthouse.jpg"   runat="server" Height="148px" Width="164px" />
    <img id="popupImage" src="Your image path goes here" alt="Popup image" style="display: none; width: auto; height: auto;"/>
        <br />
             
    </form>
    <script type="text/javascript">
        function ShowImage(src) {
            var img = document.getElementById('popupImage');
            img.src = src;
            img.style.display = "block";
        }
        function HideImage() {
            document.getElementById('popupImage').style.display = "none";
        }
</script>




</body>