byte[]转为string (急,在线等)

[huangboxi]

openFileDialog1.Filter = "jpg files (*.jpg) ¦*.jpg";
openFileDialog1.DefaultExt = "jpg";
openFileDialog1.ShowDialog();
FileStream fs1 = File.OpenRead(openFileDialog1.FileName);
byte[] content = new byte[fs1.Length];
fs1.Read(content, 0, content.Length);
fs1.Close();
Sqlcon sql1 = new Sqlcon();
SqlConnection Conn = sql1.ConnDb();
string strSql1 = "Update Ryzd Set image_f='" + content + "' Where ID_F='000001'";
Conn.Open();

SqlCommand sc1 = new SqlCommand(strSql1, Conn);
sc1.ExecuteNonQuery();
Conn.Close();

上面代码的意思是将图片保存到SQL,但直接UPDATE content到SQL,只有16位,想将content由Byte[]转为string

我想问一下如何将byte[]的值转为string
我试过用for循环来做,但太慢了
请问有什么办法来做吗？

[Jeremiah]

直接存byte就行.

参数传递用@参数.

[huangboxi]

补充:我试过用:(new UnicodeEncoding()).GetString(bytBLOBData, 0, bytBLOBData.Length)转换是不行的,出现乱码

[huangboxi]

不想用参数传递

[Jeremiah]

//这个是参数的用法.希望能给你帮一点忙...

SqlConnection conn = new SqlConnection("链接字符串");
public DataTable GetResultByQuestion(int questionID)
{
DataTable ds = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd.Connection = this.conn;
cmd.CommandText = "select * from result where question_id = @QuestionID";
cmd.Parameters.Add("@QuestionID", SqlDbType.Int);
cmd.Parameters["@QuestionID"].Value = questionID;
this.conn.Open();
SqlDataAdapter sqlDA = new SqlDataAdapter(cmd);
sqlDA.Fill(ds);
this.conn.Close();
return ds;
}


//这个是转换....
string strInput = converter.GetString(byteVariable);

[huangboxi]

这个我试过了,是可以,但我就是不想用参数传递

[Jeremiah]

这样应该就不会乱码了吧.
string content = System.Text.Encoding.UTF8.GetString(bs);

[ivan1004]

用个循环,把BYTE里的每个成员都追加到一个新字符串中就行了

[Jeremiah]

Your browser is not support range~


狂晕...

[huangboxi]

一样

2�� ��B#�R��3$b�r��CS cs4�% ���\a&5��D�T�

[huangboxi]

TO :ivan1004
这样做我试过,太慢了,响应不了

[Jeremiah]

还是建议你用Parameter传递....直接使用byte就OK了..


那我也没办法了...Sorry,水平有限帮不了你了...