How to get browser screen settings and apply it to page controls

You can use the JavaScript, suppose the control type is , see the code below:

Please remove the control style if it is present.

How to display images with a delay of five seconds

With this script you can see clickable images rotating in real-time without requiring banner rotation software or page reloads/refreshes .You should see a new banner rotating every 5 seconds:

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

        

            
        
        
    
    

Related posts: http://forums.asp.net/p/1213103/2147140.aspx

How to register the JavaScript function at Code-Behind

Use ResterStartupScript

    this.Page.ClientScript.RegisterStartupScript(this.GetType(),"alert","");

Use Literal control,

    private void Button2_Click(object sender, System.EventArgs e)
    {
        string str;
        str="

T-SQL Queries

There is a table which contains the names like this. a1, a2, a3, a3, a4, a1, a1, a2 and their salaries. Write a query to get grand total salary, and total salaries of individual employees in one query.




SELECT empid, SUM(salary) AS salary
FROM employee
GROUP BY empid WITH ROLLUP
ORDER BY empid

SQL Count Distinct

SQL Count Statement is used to count the total number of records saved in a particular table. SQL Count Statement returns total records including duplicates.
SQL Count (*) Statement does not take any other argument such bas column name to evaluate the result. It counts all columns whether they have duplicates or nulls.
E.g.:

USE NORTHWIND
SELECT COUNT (*) FROM ORDERS

Above SQL Query will return 830.

SQL Count (ALL [Column Name]) Statement returns the number of records including duplicates but excluding null value columns
E.g.:

SELECT COUNT (ALL CUSTOMERID) FROM ORDERS


SQL Count (DISTINCT [Column Name]) Statement returns unique, non null records.
E.g.:

SELECT COUNT (DISTINCT CUSTOMERID) FROM ORDERS


Above SQL Query will return 89.

Define Globally Class

public class clsGENERAL

{

    string str = ConfigurationManager.ConnectionStrings["d"].ConnectionString;

    SqlConnection con;

    SqlCommand cmd;

    SqlDataAdapter da;

    DataSet ds = new DataSet();

    public clsGENERAL()

    {

       

    }

    public int FireQuery(string qry)

    {

        con = new SqlConnection(str);

        con.Open();

        cmd = new SqlCommand(qry, con);

        int i = cmd.ExecuteNonQuery();

        con.Close();

        return i;

    }

    public DataSet SelectQuery(string qry)

    {

        con = new SqlConnection(str);

        con.Open();

        ds.Reset();

        da = new SqlDataAdapter(qry, con);

        da.Fill(ds);

        return ds;

    }

}

Encrypt/Decrypt Querystring

 First Create Class as Encrypt.cs



using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Security.Cryptography;

using System.IO;

using System.Text;



/// <summary>

/// Summary description for Encrypt

/// </summary>

public class EncryptDecryptQueryString

{

    private byte[] key = { };

    private byte[] IV = { 0x12, 0x34, 0x56, 0x78, 0x90, 0xab, 0xcd, 0xef };

    public string Decrypt(string stringToDecrypt, string sEncryptionKey)

    {

        byte[] inputByteArray = new byte[stringToDecrypt.Length + 1];

        try

        {

            key = System.Text.Encoding.UTF8.GetBytes(sEncryptionKey);

            DESCryptoServiceProvider des = new DESCryptoServiceProvider();

            inputByteArray = Convert.FromBase64String(stringToDecrypt);

            MemoryStream ms = new MemoryStream();

            CryptoStream cs = new CryptoStream(ms,

              des.CreateDecryptor(key, IV), CryptoStreamMode.Write);

            cs.Write(inputByteArray, 0, inputByteArray.Length);

            cs.FlushFinalBlock();

            System.Text.Encoding encoding = System.Text.Encoding.UTF8;

            return encoding.GetString(ms.ToArray());

        }

        catch (Exception e)

        {

            return e.Message;

        }

    }



    public string Encrypt(string stringToEncrypt, string SEncryptionKey)

    {

        try

        {

            key = System.Text.Encoding.UTF8.GetBytes(SEncryptionKey);

            DESCryptoServiceProvider des = new DESCryptoServiceProvider();

            byte[] inputByteArray = Encoding.UTF8.GetBytes(stringToEncrypt);

            MemoryStream ms = new MemoryStream();

            CryptoStream cs = new CryptoStream(ms,

              des.CreateEncryptor(key, IV), CryptoStreamMode.Write);

            cs.Write(inputByteArray, 0, inputByteArray.Length);

            cs.FlushFinalBlock();

            return Convert.ToBase64String(ms.ToArray());

        }

        catch (Exception e)

        {

            return e.Message;

        }

    }

}

---------------------

Now For Encrypt...

FirstPage.aspx

 protected void Button1_Click(object sender, EventArgs e)

    {

        string strName = "", strAge = "", strPhone = "";

        strName = "Dhruval";

        string strURL = "Executive.aspx?";

        if (HttpContext.Current != null)

        {

            string strURLWithData = strURL +

              EncryptQueryString(string.Format("Name={0}",

              strName));

            HttpContext.Current.Response.Redirect(strURLWithData);

        }

        else

        { }

    }



public string EncryptQueryString(string strQueryString)

    {

        EncryptDecryptQueryString objEDQueryString = new EncryptDecryptQueryString();

        return objEDQueryString.Encrypt(strQueryString, "r0b1nr0y");

    }



-------------------

SecondPage.aspx

 if (!IsPostBack)

        {

            string strReq = "";

            strReq = Request.RawUrl;

            strReq = strReq.Substring(strReq.IndexOf('?') + 1);



            if (!strReq.Equals(""))

            {

                strReq = DecryptQueryString(strReq);



                //Parse the value... this is done is very raw format..

                //you can add loops or so to get the values out of the query string...

                string[] arrMsgs = strReq.Split('&');

                string[] arrIndMsg;

                string strName = "", strAge = "", strPhone = "";

                arrIndMsg = arrMsgs[0].Split('='); //Get the Name

                strName = arrIndMsg[1].ToString().Trim();

                //arrIndMsg = arrMsgs[1].Split('='); //Get the Age

                //strAge = arrIndMsg[1].ToString().Trim();

                //arrIndMsg = arrMsgs[2].Split('='); //Get the Phone

                //strPhone = arrIndMsg[1].ToString().Trim();



                lblName.Text = strName;



            }

            else

            {

                Response.Redirect("Page1.aspx");

            }

        } 

MIME For Downloading Documents

Multipurpose Internet Mail Extensions (MIME) is an Internet standard that extends the format of e-mail to support:

• Text in character sets other than ASCII
• Non-text attachments
• Message bodies with multiple parts
• Header information in non-ASCII character sets

MIME's use, however, has grown beyond describing the content of e-mail to describe content type in general, including for the web (see Internet media type) and as a storage for rich content in some commercial products (e.g., IBM Lotus Domino and IBM Lotus Quickr).
Virtually all human-written Internet e-mail and a fairly large proportion of automated e-mail is transmitted via SMTP in MIME format. Internet e-mail is so closely associated with the SMTP and MIME standards that it is sometimes called SMTP/MIME e-mail.


Code For Dynamic MIME Types:
string Path = "~/images/arrow.gif";
        string FileName = "arrow";
        string Extension = ".gif";
        string type = "";
        if (Extension != null)
        {
            switch (Extension.ToLower())
            {
                case ".htm":
                case ".html":
                    type = "text/HTML";
                    break;
                case ".doc":
                case ".rtf":
                case ".docx":
                    type = "Application/msword";
                    break;
                case ".gif":
                    type = "image/gif";
                    break;
            }
            Response.AppendHeader("content-disposition",
        "attachment; filename=" + FileName);
            if (type != "")
                Response.ContentType = type;
            Response.WriteFile(Path);
            Response.End();




Some Other MIME Examples:

file type	MIME type
ai	application/postscript
aif	audio/x-aiff
aifc	audio/x-aiff
aiff	audio/x-aiff
asc	text/plain
atom	application/atom+xml
au	audio/basic
avi	video/x-msvideo
bcpio	application/x-bcpio
bin	application/octet-stream
bmp	image/bmp
cdf	application/x-netcdf
cgm	image/cgm
class	application/octet-stream
cpio	application/x-cpio
cpt	application/mac-compactpro
csh	application/x-csh
css	text/css
dcr	application/x-director
dif	video/x-dv
dir	application/x-director
djv	image/vnd.djvu
djvu	image/vnd.djvu
dll	application/octet-stream
dmg	application/octet-stream
dms	application/octet-stream
doc	application/msword
dtd	application/xml-dtd
dv	video/x-dv
dvi	application/x-dvi
dxr	application/x-director
eps	application/postscript
etx	text/x-setext
exe	application/octet-stream
ez	application/andrew-inset
gif	image/gif
gram	application/srgs
grxml	application/srgs+xml
gtar	application/x-gtar
hdf	application/x-hdf
hqx	application/mac-binhex40
htm	text/html
html	text/html
ice	x-conference/x-cooltalk
ico	image/x-icon
ics	text/calendar
ief	image/ief
ifb	text/calendar
iges	model/iges
igs	model/iges
jnlp	application/x-java-jnlp-file
jp2	image/jp2
jpe	image/jpeg
jpeg	image/jpeg
jpg	image/jpeg
js	application/x-javascript
kar	audio/midi
latex	application/x-latex
lha	application/octet-stream
lzh	application/octet-stream
m3u	audio/x-mpegurl
m4a	audio/mp4a-latm
m4b	audio/mp4a-latm
m4p	audio/mp4a-latm
m4u	video/vnd.mpegurl
m4v	video/x-m4v
mac	image/x-macpaint
man	application/x-troff-man
mathml	application/mathml+xml
me	application/x-troff-me
mesh	model/mesh
mid	audio/midi
midi	audio/midi
mif	application/vnd.mif
mov	video/quicktime
movie	video/x-sgi-movie
mp2	audio/mpeg
mp3	audio/mpeg
mp4	video/mp4
mpe	video/mpeg
mpeg	video/mpeg
mpg	video/mpeg
mpga	audio/mpeg
ms	application/x-troff-ms
msh	model/mesh
mxu	video/vnd.mpegurl
nc	application/x-netcdf
oda	application/oda
ogg	application/ogg
pbm	image/x-portable-bitmap
pct	image/pict
pdb	chemical/x-pdb
pdf	application/pdf
pgm	image/x-portable-graymap
pgn	application/x-chess-pgn
pic	image/pict
pict	image/pict
png	image/png
pnm	image/x-portable-anymap
pnt	image/x-macpaint
pntg	image/x-macpaint
ppm	image/x-portable-pixmap
ppt	application/vnd.ms-powerpoint
ps	application/postscript
qt	video/quicktime
qti	image/x-quicktime
qtif	image/x-quicktime
ra	audio/x-pn-realaudio
ram	audio/x-pn-realaudio
ras	image/x-cmu-raster
rdf	application/rdf+xml
rgb	image/x-rgb
rm	application/vnd.rn-realmedia
roff	application/x-troff
rtf	text/rtf
rtx	text/richtext
sgm	text/sgml
sgml	text/sgml
sh	application/x-sh
shar	application/x-shar
silo	model/mesh
sit	application/x-stuffit
skd	application/x-koan
skm	application/x-koan
skp	application/x-koan
skt	application/x-koan
smi	application/smil
smil	application/smil
snd	audio/basic
so	application/octet-stream
spl	application/x-futuresplash
src	application/x-wais-source
sv4cpio	application/x-sv4cpio
sv4crc	application/x-sv4crc
svg	image/svg+xml
swf	application/x-shockwave-flash
t	application/x-troff
tar	application/x-tar
tcl	application/x-tcl
tex	application/x-tex
texi	application/x-texinfo
texinfo	application/x-texinfo
tif	image/tiff
tiff	image/tiff
tr	application/x-troff
tsv	text/tab-separated-values
txt	text/plain
ustar	application/x-ustar
vcd	application/x-cdlink
vrml	model/vrml
vxml	application/voicexml+xml
wav	audio/x-wav
wbmp	image/vnd.wap.wbmp
wbmxl	application/vnd.wap.wbxml
wml	text/vnd.wap.wml
wmlc	application/vnd.wap.wmlc
wmls	text/vnd.wap.wmlscript
wmlsc	application/vnd.wap.wmlscriptc
wrl	model/vrml
xbm	image/x-xbitmap
xht	application/xhtml+xml
xhtml	application/xhtml+xml
xls	application/vnd.ms-excel
xml	application/xml
xpm	image/x-xpixmap
xsl	application/xml
xslt	application/xslt+xml
xul	application/vnd.mozilla.xul+xml
xwd	image/x-xwindowdump
xyz	chemical/x-xyz
zip	application/zip

What a Wondurful World

And Today is My Life's most precious Day...

Encryption And Store In Database

Description

First we will learn what is encryption and decryption

Encryption is the process of translating plain text data into something that appears to be random and meaningless.

Decryption is the process of translating random and meaningless data to plain text.

Why we need to use this Encryption and decryption processes

 By using this process we can hide original data and display some junk data based on this we can provide some security for our data.

Here I will explain how to encrypt data and how to save that data into database after that I will show how to decrypt that encrypted data in database and how we can display that decrypted data on form.

I have a form with four fileds username, password, firstname, lastname here I am encrypting password data and saving that data into database after that I am getting from database and decrypting the encrypted password data and displaying that data using gridview.

Design your aspx like this 

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

<head runat="server">

<title></title>

</head>

<body>

<form id="form1" runat="server">

<div>

<table align="center">

<tr>

<td colspan="2">

<b>Encryption and Decryption of Password</b>

</td>

</tr>

<tr>

<td>

UserName

</td>

<td>

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

</td>

</tr>

<tr>

<td>

Password

</td>

<td>

<asp:TextBox ID="txtPassword" runat="server" TextMode="Password"></asp:TextBox>

</td>

</tr>

<tr>

<td>

FirstName

</td>

<td>

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

</td>

</tr>

<tr>

<td>

LastName

</td>

<td>

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

</td>

</tr>

<tr>

<td>

</td>

<td>

<asp:Button ID="btnSubmit" runat="server" Text="Submit"

onclick="btnSubmit_Click" />

</td>

</tr>

</table>

</div>

<div>

<table align="center">

<tr>

<td>

<b>Encryption of Password Details</b>

</td>

</tr>

<tr>

<td>

<asp:GridView ID="gvUsers" runat="server" CellPadding="4" BackColor="White"

BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px">

<RowStyle BackColor="White" ForeColor="#330099" />

<FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />

<PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />

<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />

<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC"

HorizontalAlign="Left"/>

</asp:GridView>

</td>

</tr>

</table>

</div>

<div>

<table align="center">

<tr>

<td>

<b>Decryption of Password Details</b>

</td>

</tr>

<tr>

<td>

<asp:GridView ID="gvdecryption" runat="server" BackColor="White"

BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" CellPadding="4"

onrowdatabound="gvdecryption_RowDataBound">

<RowStyle BackColor="White" ForeColor="#330099" />

<FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />

<PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />

<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />

<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />

</asp:GridView>

</td>

</tr>

</table>

</div>

</form>

</body>

</html>

After that add System.Text namespace in code behind because in this namespace contains classes representing ASCII and Unicode character encodings

After that add following code in code behind and design one table in database with four fields and give name as "SampleUserdetails"

private const string strconneciton = "Data Source=MYCBJ017550027;Initial Catalog=MySamplesDB;Integrated Security=True";

SqlConnection con = new SqlConnection(strconneciton);

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindencryptedData();

BindDecryptedData();

}

}

/// <summary>

/// btnSubmit event is used to insert user details with password encryption

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void btnSubmit_Click(object sender, EventArgs e)

{

string strpassword = Encryptdata(txtPassword.Text);

con.Open();

SqlCommand cmd = new SqlCommand("insert into SampleUserdetails(UserName,Password,FirstName,LastName) values('" + txtname.Text + "','" + strpassword + "','" + txtfname.Text + "','" + txtlname.Text + "')", con);

cmd.ExecuteNonQuery();

con.Close();

BindencryptedData();

BindDecryptedData();

}

/// <summary>

/// Bind user Details to gridview

/// </summary>

protected void BindencryptedData()

{

con.Open();

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

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

gvUsers.DataSource = ds;

gvUsers.DataBind();

con.Close();

}

/// <summary>

/// Bind user Details to gridview

/// </summary>

protected void BindDecryptedData()

{

con.Open();

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

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

gvdecryption.DataSource = ds;

gvdecryption.DataBind();

con.Close();

}

/// <summary>

/// Function is used to encrypt the password

/// </summary>

/// <param name="password"></param>

/// <returns></returns>

private string Encryptdata(string password)

{

string strmsg = string.Empty;

byte[] encode = new byte[password.Length];

encode = Encoding.UTF8.GetBytes(password);

strmsg = Convert.ToBase64String(encode);

return strmsg;

}

/// <summary>

/// Function is used to Decrypt the password

/// </summary>

/// <param name="password"></param>

/// <returns></returns>

private string Decryptdata(string encryptpwd)

{

string decryptpwd = string.Empty;

UTF8Encoding encodepwd = new UTF8Encoding();

Decoder Decode = encodepwd.GetDecoder();

byte[] todecode_byte = Convert.FromBase64String(encryptpwd);

int charCount = Decode.GetCharCount(todecode_byte, 0, todecode_byte.Length);

char[] decoded_char = new char[charCount];

Decode.GetChars(todecode_byte, 0, todecode_byte.Length, decoded_char, 0);

decryptpwd = new String(decoded_char);

return decryptpwd;

}

/// <summary>

/// rowdatabound condition is used to change the encrypted password format to decryption format

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void gvdecryption_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

string decryptpassword = e.Row.Cells[2].Text;

e.Row.Cells[2].Text = Decryptdata(decryptpassword);

}

}

Hope It Helps...