Wandering in an unknown path, searching for my DESTINATION

Sunday, 5 August 2012

Read or Write connection strings in web.config file using asp.net

open web.config file in application and add sample db connection in connectionStrings section like this

</connectionStrings >

Example of declaring connectionStrings in web.config file like this

</connectionStrings >

After add dbconnection in connectionString we need to write the some code in our codebehind file to get connection string from web.config file for that add following namespace in codebehind file and write the following code

using System.Configuration;

This namespace is used to get configuration section details from web.config file.

After add namespaces write the following code in code behind

C# code

using System;

using System.Data.SqlClient;

using System.Configuration;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

//Get connection string from web.config file

string strcon = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;

//create new sqlconnection and connection to database by using connection string from web.config file

SqlConnection con = new SqlConnection(strcon);

con.Open();

}

VB.NET

Imports System.Data.SqlClient

Imports System.Configuration

Partial Public Class _Default

Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)

'Get connection string from web.config file

Dim strcon As String = ConfigurationManager.ConnectionStrings("dbconnection").ConnectionString

'create new sqlconnection and connection to database by using connection string from web.config file

Dim con As New SqlConnection(strcon)

con.Open()

End Sub

End Class

Encrypt and Decrypt the password

Design your aspx like this

</head>

<body>

<div>

<tr>

<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>

<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">

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

HorizontalAlign="Left"/>

</asp:GridView>

</td>

</tr>

</table>

</div>

<div>

<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">

</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);

}

Demo

Wednesday, 9 May 2012

Extract the data from the file

Extract the data from the file uploaded, and show it on the web page :

Using a file uploader control, the file is being uploaded and the filepath has been retrieved , then the data of the file is extracted. The code below will extract the word/ excel files' data. The "microsoft word" reference must be added :

using Microsoft.Office.Interop;
using System.Runtime.InteropServices.ComTypes;
using Microsoft.Office.Interop.Word;

protected void Button1_Click(object sender, EventArgs e)
    {

        object filePath = (object)FileUpload1.PostedFile.FileName;// ur filepath...

      ApplicationClass wordApp = new ApplicationClass();

    object nullobj = System.Reflection.Missing.Value;

    Microsoft.Office.Interop.Word.Document doc = wordApp.Documents.Open(
    ref filePath, ref nullobj, ref nullobj,
    ref nullobj, ref nullobj, ref nullobj,
    ref nullobj, ref nullobj, ref nullobj,
    ref nullobj, ref nullobj, ref nullobj, ref nullobj,
    ref nullobj, ref nullobj, ref nullobj);

    doc.ActiveWindow.Selection.WholeStory();

    doc.ActiveWindow.Selection.Copy();

    string sFileText = doc.Content.Text;

    doc.Close(ref nullobj, ref nullobj, ref nullobj);

    wordApp.Quit(ref nullobj, ref nullobj, ref nullobj);

    Response.Write(sFileText);
}

For the PDF file the code is :

protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Clear();
        string filePath = FileUpload1.PostedFile.FileName.ToString(); //ur file path on the server
        Response.ContentType = "application/pdf";    //"application/ms-word";
        Response.WriteFile(filePath);
    }

For the Text /notepad file the code will be:

System.IO.StreamReader sr = new System.IO.StreamReader(filePath);
        string line;
        while (sr.Peek() != -1)
        {
            Response.Clear();
            line = sr.ReadLine();
            Response.Write(Server.HtmlEncode(line) + "<br/>");
         }

Monday, 16 April 2012

UPLOADING A FILE

FILE UPLOADING:

string filename = "filename from Database";
Response.ContentType = "application/octet-stream";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + filename);
string aaa = Server.MapPath("~/SavedFolder/" + filename);
Response.TransmitFile(Server.MapPath("~/SavedFolder/" + filename));
Response.End();

caps lock detection

DETECTING CAPS LOCK ON IN A TEXTBOX

In the textbox keypress event a function is called :
<div><asp:TextBox ID="TextBox1" runat="server" onKeypress="isCapLockOn(event)"></asp:TextBox><
</

Now the function is defined as follows :

<script language="javascript" type="text/javascript">

|| ((charKeyCode >= 97 && charKeyCode <= 122) && shiftKey)) {
document.getElementById(
}

document.getElementById(
}
}
function isCapLockOn(e) {var charKeyCode = e.keyCode ? e.keyCode : e.which;var shiftKey = e.shiftKey ? e.shiftKey : ((charKeyCode == 16) ? true : false);if (((charKeyCode >= 65 && charKeyCode <= 90) && !shiftKey)'keyStage').innerHTML = "Caps lock : <b>On</b>";else {'keyStage').innerHTML = "Caps lock : <b>Off</b>";</script>
div id="keyStage" style="color:Red;font-size:80%;"></div>div>