hi SuperSpike,
Based on your description and my understanding, I created a helper class to help you to convert the binary to string, you can add it to the App_Code foler and use it directly
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
public sealed class strhelper
{
public static void hexbin2hex(byte[] bhexbin, byte[] bhex, int nlen)
{
for (int i = 0; i < nlen / 2; i++)
{
if (bhexbin[2 * i] < 0x41)
{
bhex[i] = Convert.ToByte(((bhexbin[2 * i] - 0x30) << 4) & 0xf0);
}
else
{
bhex[i] = Convert.ToByte(((bhexbin[2 * i] - 0x37) << 4) & 0xf0);
}
if (bhexbin[2 * i + 1] < 0x41)
{
bhex[i] |= Convert.ToByte((bhexbin[2 * i + 1] - 0x30) & 0x0f);
}
else
{
bhex[i] |= Convert.ToByte((bhexbin[2 * i + 1] - 0x37) & 0x0f);
}
}
}
public static byte[] hexbin2hex(byte[] bhexbin, int nlen)
{
if (nlen % 2 != 0)
return null;
byte[] bhex = new byte[nlen / 2];
hexbin2hex(bhexbin, bhex, nlen);
return bhex;
}
public static void hex2hexbin(byte[] bhex, byte[] bhexbin, int nlen)
{
byte c;
for (int i = 0; i < nlen; i++)
{
c = Convert.ToByte((bhex[i] >> 4) & 0x0f);
if (c < 0x0a)
{
bhexbin[2 * i] = Convert.ToByte(c + 0x30);
}
else
{
bhexbin[2 * i] = Convert.ToByte(c + 0x37);
}
c = Convert.ToByte(bhex[i] & 0x0f);
if (c < 0x0a)
{
bhexbin[2 * i + 1] = Convert.ToByte(c + 0x30);
}
else
{
bhexbin[2 * i + 1] = Convert.ToByte(c + 0x37);
}
}
}
public static byte[] hex2hexbin(byte[] bhex, int nlen)
{
byte[] bhexbin = new byte[nlen * 2];
hex2hexbin(bhex, bhexbin, nlen);
return bhexbin;
}
#endregion
public static byte[] str2arr(string s)
{
return (new UnicodeEncoding()).GetBytes(s);
}
public static string arr2str(byte[] buffer)
{
return (new UnicodeEncoding()).GetString(buffer, 0,buffer .Length );
}
public static byte[] str2ascarr(string s)
{
return System.Text.UnicodeEncoding .Convert (System .Text .Encoding .Unicode ,System .Text .Encoding .ASCII ,str2arr(s));
}
public static byte[] str2hexascarr(string s)
{
byte[] hex = str2ascarr(s);
byte[] hexbin = hex2hexbin(hex, hex.Length );
return hexbin;
}
public static string ascarr2str(byte[] b)
{
return System.Text.UnicodeEncoding.Unicode.GetString(System.Text.ASCIIEncoding.Convert(System.Text.Encoding.ASCII, System.Text.Encoding.Unicode, b));
}
public static string hexascarr2str(byte[] buffer)
{
byte[] b = hex2hexbin(buffer, buffer .Length );
return ascarr2str(b);
}
#endregion
}
Using it in .aspx page
protected void Button2_Click(object sender, EventArgs e)
{
string connect = "Data Source=localhost\\sqlexpress;Integrated Security=True;Initial Catalog=pubs;";
System.Data.SqlClient.SqlConnection sqlconnect = new System.Data.SqlClient.SqlConnection(connect);
string command = "select myString from stringBinary";
System.Data.SqlClient.SqlCommand sqlcommand = new System.Data.SqlClient.SqlCommand();
sqlcommand.CommandText = command;
sqlcommand.Connection = sqlconnect;
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter();
da.SelectCommand = sqlcommand;
DataSet ds = new DataSet();
sqlconnect.Open();
sqlcommand.ExecuteNonQuery();
da.Fill(ds);
TextBox1.Text = strhelper.ascarr2str((byte[])ds.Tables[0].Rows[0][0]);
// then use TextBox.Text.Contains() to find whether the string contain a certain string
sqlconnect.Close();
}
Hope it helps,
Jessica