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();
}
}