string 转换为 byte[] 、byte[] 转换为 string
来源:互联网 发布:网络主播小可爱 编辑:程序博客网 时间:2024/04/29 19:54
Using System.Text;
byte[ ] 转换为string
byte[ ] image;
string ll = Encoding.Default.GetString(image);
string 转换为byte[ ]
string ss;
byte[] b = Encoding.Default.GetBytes(ss);
数据库中image类型的字段的处理。
从数据库中读出图片(以image类型存储的), 并且写入txt文件中:
private void GetImage()
{
string conn = "Server=192.168.0.11; User id=user; Pwd=pwd; Database=database";
SqlConnection sqlCon = new SqlConnection(conn);
string sql = "SELECT ImageFile, PersonID FROM Persons where PersonID = 1";
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = sqlCon;
myCommand.CommandType = CommandType.Text;
myCommand.CommandText = sql;
DataTable myTable = new DataTable();
SqlDataAdapter myDataAda = new SqlDataAdapter();
myDataAda.SelectCommand = myCommand;
try
{
sqlCon.Open();
myDataAda.Fill(myTable);
sqlCon.Close();
if(myTable.Rows.Count>0)
{
byte[] image = (byte[])myTable.Rows[0]["ImageFile"];
string ll = Encoding.Default.GetString(image);
WriteStr(@"F:\test.txt",ll);
}
}
catch(Exception ex)
{
string err = ex.Message;
}
finally
{
sqlCon.Close();
myCommand.Dispose();
myDataAda.Dispose();
}
}
private void WriteStr(string strLogFileName, string strLogContent)
{
try
{
FileInfo objFileInfo = new FileInfo(strLogFileName);
using (FileStream objFileStream = objFileInfo.OpenWrite())
{
using (StreamWriter objStreamWriter = new StreamWriter(objFileStream))
{
objStreamWriter.BaseStream.Seek(0, SeekOrigin.End);
objStreamWriter.Write("{0}", strLogContent);
}
}
}
catch
{
}
}
其次,需要把图片从txt文件中读出然后存入数据库中。
string ss = ReadStr(@"F:\test.txt");
byte[] b = Encoding.Default.GetBytes(ss);
string conn = "Server=server; User id=user; Pwd=pwd; Database=database";
SqlConnection sqlCon = new SqlConnection(conn);
string sql = "update Persons set ImageFile=@img where PersonID = 1";
SqlCommand myCommand = new SqlCommand();
SqlParameter sp = new SqlParameter("@img",SqlDbType.Image);
myCommand.Connection = sqlCon;
myCommand.CommandType = CommandType.Text;
myCommand.CommandText = sql;
sp.Value = b;
myCommand.Parameters.Add(sp);
try
{
sqlCon.Open();
myCommand.ExecuteNonQuery();
sqlCon.Close();
}
catch(Exception eS)
{
string ee = eS.Message;
}
finally
{
sqlCon.Close();
myCommand.Dispose();
}
byte[ ] 转换为string
byte[ ] image;
string ll = Encoding.Default.GetString(image);
string 转换为byte[ ]
string ss;
byte[] b = Encoding.Default.GetBytes(ss);
数据库中image类型的字段的处理。
从数据库中读出图片(以image类型存储的), 并且写入txt文件中:
private void GetImage()
{
string conn = "Server=192.168.0.11; User id=user; Pwd=pwd; Database=database";
SqlConnection sqlCon = new SqlConnection(conn);
string sql = "SELECT ImageFile, PersonID FROM Persons where PersonID = 1";
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = sqlCon;
myCommand.CommandType = CommandType.Text;
myCommand.CommandText = sql;
DataTable myTable = new DataTable();
SqlDataAdapter myDataAda = new SqlDataAdapter();
myDataAda.SelectCommand = myCommand;
try
{
sqlCon.Open();
myDataAda.Fill(myTable);
sqlCon.Close();
if(myTable.Rows.Count>0)
{
byte[] image = (byte[])myTable.Rows[0]["ImageFile"];
string ll = Encoding.Default.GetString(image);
WriteStr(@"F:\test.txt",ll);
}
}
catch(Exception ex)
{
string err = ex.Message;
}
finally
{
sqlCon.Close();
myCommand.Dispose();
myDataAda.Dispose();
}
}
private void WriteStr(string strLogFileName, string strLogContent)
{
try
{
FileInfo objFileInfo = new FileInfo(strLogFileName);
using (FileStream objFileStream = objFileInfo.OpenWrite())
{
using (StreamWriter objStreamWriter = new StreamWriter(objFileStream))
{
objStreamWriter.BaseStream.Seek(0, SeekOrigin.End);
objStreamWriter.Write("{0}", strLogContent);
}
}
}
catch
{
}
}
其次,需要把图片从txt文件中读出然后存入数据库中。
string ss = ReadStr(@"F:\test.txt");
byte[] b = Encoding.Default.GetBytes(ss);
string conn = "Server=server; User id=user; Pwd=pwd; Database=database";
SqlConnection sqlCon = new SqlConnection(conn);
string sql = "update Persons set ImageFile=@img where PersonID = 1";
SqlCommand myCommand = new SqlCommand();
SqlParameter sp = new SqlParameter("@img",SqlDbType.Image);
myCommand.Connection = sqlCon;
myCommand.CommandType = CommandType.Text;
myCommand.CommandText = sql;
sp.Value = b;
myCommand.Parameters.Add(sp);
try
{
sqlCon.Open();
myCommand.ExecuteNonQuery();
sqlCon.Close();
}
catch(Exception eS)
{
string ee = eS.Message;
}
finally
{
sqlCon.Close();
myCommand.Dispose();
}
- byte[]转换为String
- string 转换为 byte[] 、byte[] 转换为 string
- 把byte[]转换为String
- C# 将byte[] 转换为 string
- 将String 转换为byte[]数组
- 转换一个String字符串为byte数组
- String字符串转换为byte byte转换为String字符串 汉字乱码问题
- 在C#中如何使用BYTE[]转换为String
- Android将InputStream转换为String和byte[]
- java 如何将byte中的有效长度转换为String
- C++将byte转换为string(16进制)
- Java byte[]字节数组转换为String字符串的注意事项
- java 如何将byte中的有效长度转换为String
- string byte[]的转换
- C# string byte[] 转换
- string int byte转换
- c# byte[] string 转换
- byte[] string相互转换
- 2012文山事业单位招聘考试
- 课程设计赫夫曼编码
- 资治通鉴,资治通鉴里的义与不义,防人之心不可无
- Sruts2.1+JPA(Hibernate3.0)+Spring2.5整合详解
- 实验名称: :Huffman编码(二叉树应用)
- string 转换为 byte[] 、byte[] 转换为 string
- java 仿c/c++ 中#define #ifdef 的功能做Debug(转载)
- 编写递归算法 计算二叉树中叶子节点的个数
- Eclipse下项目工作集管理
- 学习网址
- XMLOperator[C#]
- http://projecteuler.net/problem=33 [Answer:100]
- 连接到数据库(标准)
- Android中animation方面知识: Android:interpolator 属性