Encrypt With using md5 Hasher and insert data to data base

using System;
using System.Data;
using System.Collections.Specialized;
using SubsonicTool;
using System.Configuration;
using System.Data.SqlClient;
using System.Security.Cryptography;

partial class Default2 : System.Web.UI.Page
{
string temp = string.Empty;

protected void Button1_Click(object sender, System.EventArgs e)
{
//Try


MD5CryptoServiceProvider md5Hasher = new MD5CryptoServiceProvider();
UTF8Encoding encoder = new UTF8Encoding();

SqlDataReader sqlDataReader;
SqlCommand sqlCommand = new SqlCommand();

string ConnString = "";
string sql = "";
ConnString = ConfigurationManager.ConnectionStrings("myconnection").ConnectionString;
SqlConnection SqlObj = new SqlConnection(ConnString);
SqlConnection SqlObj1 = new SqlConnection(ConnString);
SqlObj.Open();


{
sqlCommand.Connection = SqlObj;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "TestINSERT";
sqlDataReader = sqlCommand.ExecuteReader();
}


Int16 intno = 1;
Int16 intbig = 1;
string rata = "LK";

while (sqlDataReader.Read()) {

string strSQL2 = "INSERT INTO aca_user (username,password ,lastname,firstname,address,city,email,confirmed,mnethostid,country) Values (@col1, @col2,@col3, @col4,@col5, @col6,@col7,@col8,@col9,@col10)";
ConnString = ConfigurationManager.ConnectionStrings("myconnection").ConnectionString;



SqlObj1.Open();
System.Data.SqlClient.SqlCommand sqlCmd = new System.Data.SqlClient.SqlCommand(strSQL2, SqlObj1);

{
sqlCmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@col1", sqlDataReader("UserName")));
sqlCmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@col2", encryptpassword(sqlDataReader("Password"))));
sqlCmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@col3", sqlDataReader("SurName")));
sqlCmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@col4", sqlDataReader("NameUsedInUniversity")));
sqlCmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@col5", sqlDataReader("PermanentAddress")));
sqlCmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@col6", chceknullcity(sqlDataReader("City"))));
sqlCmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@col7", sqlDataReader("Email")));
sqlCmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@col8", intno));
sqlCmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@col9", intbig));
sqlCmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@col10", rata));
}


sqlCmd.ExecuteNonQuery();
SqlObj1.Close();

}


GridView1.DataSource = sqlDataReader;
GridView1.DataBind();



sqlDataReader.Close();

SqlObj.Close();
//Catch ex As Exception
// Label1.Text = (ex.Message)
//End Try
}

//Convert the password into MD5 encrypting
public object encryptpassword(string str)
{
MD5CryptoServiceProvider md5Hasher = new MD5CryptoServiceProvider();
UTF8Encoding encoder = new UTF8Encoding();
return ByteArrayToString(md5Hasher.ComputeHash(Encoder.GetBytes(str)));
}

//Conversion- to the encrypted data to hexadecimal format

public object ByteArrayToString(byte[] byteArray)
{
byte b;
string temp = string.Empty;
foreach ( b in byteArray) {
temp &= IIf((Conversion.Hex(b).Length = 2), Conversion.Hex(b).ToLower, "0" + Conversion.Hex(b).ToLower)

}
return temp.ToString();
}
}

How To Insert Data To DataTable by Reading The Excel Sheet

using System;
using System.Data;
using System.Collections.Specialized;
using SubsonicTool;
using System.Configuration;
using System.Data.SqlClient;
using System.Security.Cryptography;
using System.Byte;
using System.Data.OleDb;
using System.Text;
using System.IO;


partial class ExcelImport : System.Web.UI.Page
{
#region "Private Members"


#endregion

protected void Button1_Click(object sender, System.EventArgs e)
{
try {

string filepath;
if ((FileUpload1.PostedFile.ContentLength == 0)) { //rejecting a zero length file
Label1.Text = "Cannot upload zero length file";
return;
}
FileUpload1.PostedFile.SaveAs("C:\\Book1.xls");

filepath = ("C:\\Book1.xls"); //Getting the excel file


**************************
//connection of the excel sheet goes here initalic
StringBuilder sbConn = new StringBuilder();

sbConn.Append("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=");
sbConn.Append(filepath);

sbConn.Append(";Extended Properties=");
sbConn.Append(Convert.ToChar(34));
sbConn.Append("Excel 8.0;HDR=Yes;IMEX=2");
sbConn.Append(Convert.ToChar(34));

**************************
//connection of the data abse part goes here initalic

OleDbConnection cnExcel = new OleDbConnection(sbConn.ToString);
cnExcel.Open();


OleDbDataAdapter xlDataAda = new OleDbDataAdapter(" Select * From [Sheet1$]", cnExcel);

DataTable xlDataTbl = new DataTable();
xlDataAda.Fill(xlDataTbl);





cnExcel.Close();


SqlCommand sqlCommand = new SqlCommand();

string ConnString = "";
string sql = "";
ConnString = ConfigurationManager.ConnectionStrings("/*connection Name*/").ConnectionString;
SqlConnection SqlObj = new SqlConnection(ConnString);

SqlObj.Open();
SqlCommand cmd = SqlObj.CreateCommand;


cmd.CommandText = "SELECT * FROM /*tablename*/";
cmd.ExecuteNonQuery();

SqlDataAdapter sqldataAdp = new SqlDataAdapter(cmd);
SqlCommandBuilder sqlComBul = new SqlCommandBuilder(sqldataAdp);
DataSet sqlDataSet = new DataSet();
sqldataAdp.Fill(sqlDataSet, "/*tablename*/");


foreach (DataRow xlrow in xlDataTbl.Rows) {
DataRow dr = sqlDataSet.Tables("/*tablename*/").NewRow;

string username;
string password;
string intial;
string Donintial;

foreach (DataColumn col1 in xlDataTbl.Columns) {


if (col1.ColumnName.ToString == "/*column name 1*/") {
username = xlrow(col1.ColumnName);
}

else if (col1.ColumnName.ToString == "/*column name 2*/") {
password = Crypto.Lock(xlrow(col1.ColumnName));
}
else if (col1.ColumnName.ToString == "/*column name 3*/") {
intial = (xlrow(col1.ColumnName));
}
else if (col1.ColumnName.ToString == "/*column name 4*/") {
Donintial = (xlrow(col1.ColumnName));
}






}

//your sp or data insert part goes here


}

Label1.Text = "weldone";


sqldataAdp.Dispose();
SqlObj.Close();

File.Delete("C:\\Book1.xls");
}


catch (Exception ex) {
if (ex.Message.Contains("Column '/*column name 1*/' does not belong to table .")) {

Label1.Text = "You Have To Modify The Excel File /*column name 1*/Column As :-UserName And Password:-Password ";
}

else if (ex.Message.Contains("Cannot insert duplicate key in object ")) {
Label1.Text = "You Are try to enterted values to the db";
}
else {

Label1.Text = ex.Message.ToString;
}

}


}

}

How to Add datas to data grid

con = new SqlConnection("server=DAMITH\\SQL2005;database=Test;user=sa;password=123;");
con.Open();
SqlDataAdapter thisadapter = new SqlDataAdapter("SELECT * FROM LoginTable ", con);
DataSet thisdataset=new DataSet();

thisadapter.Fill(thisdataset);
DataGrid1.DataSource =thisdataset ;
DataGrid1.DataBind();


con.Close();