/// <summary>
/// 得到一个image字段的内容
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="fieldName">字段名(必须为image类型字段)</param>
/// <param name="condition">查询条件</param>
/// <returns>字段的所有内容</returns>
public static byte[] getImage(string tableName,string fieldName,string condition)
{
byte[] b = null;
string strSql = "select " + fieldName + " from " + tableName + " where " + condition;
SqlConnection conn = null;
try
{
conn = Connect.getConnection();
SqlCommand myCommand = new SqlCommand(strSql,conn);
SqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
SqlBinary binary = myReader.GetSqlBinary(0);
if (!binary.IsNull)
{
b = binary.Value;
}
}
myReader.Close();
}
catch(Exception ex)
{
Log.Write("",ex.Message + " 语句为: " + strSql,System.Diagnostics.EventLogEntryType.Error,1);
}
finally
{
conn.Close();
}
return b;
}
/// <summary>
/// 写入一个image字段
/// </summary>
/// <param name="b">要写入的二进制流</param>
/// <param name="tableName">表名</param>
/// <param name="fieldName">字段名</param>
/// <param name="condition">查询条件</param>
public static void setImage(byte[] b,string tableName,string fieldName,string condition)
{
string strSql = "update " + tableName + " set " + fieldName + " = @imgdata where " + condition;
SqlConnection conn = null;
try
{
conn = Connect.getConnection();
SqlCommand myCommand = new SqlCommand(strSql,conn);
myCommand.Parameters.Add("@imgdata",SqlDbType.Image).Value = b;
myCommand.ExecuteNonQuery();
}
catch(Exception ex)
{
Log.Write("",ex.Message + " 语句为: " + strSql,System.Diagnostics.EventLogEntryType.Error,1);
}
finally
{
conn.Close();
}
}看看是否对你有帮助。
/// 得到一个image字段的内容
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="fieldName">字段名(必须为image类型字段)</param>
/// <param name="condition">查询条件</param>
/// <returns>字段的所有内容</returns>
public static byte[] getImage(string tableName,string fieldName,string condition)
{
byte[] b = null;
string strSql = "select " + fieldName + " from " + tableName + " where " + condition;
SqlConnection conn = null;
try
{
conn = Connect.getConnection();
SqlCommand myCommand = new SqlCommand(strSql,conn);
SqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
SqlBinary binary = myReader.GetSqlBinary(0);
if (!binary.IsNull)
{
b = binary.Value;
}
}
myReader.Close();
}
catch(Exception ex)
{
Log.Write("",ex.Message + " 语句为: " + strSql,System.Diagnostics.EventLogEntryType.Error,1);
}
finally
{
conn.Close();
}
return b;
}
/// <summary>
/// 写入一个image字段
/// </summary>
/// <param name="b">要写入的二进制流</param>
/// <param name="tableName">表名</param>
/// <param name="fieldName">字段名</param>
/// <param name="condition">查询条件</param>
public static void setImage(byte[] b,string tableName,string fieldName,string condition)
{
string strSql = "update " + tableName + " set " + fieldName + " = @imgdata where " + condition;
SqlConnection conn = null;
try
{
conn = Connect.getConnection();
SqlCommand myCommand = new SqlCommand(strSql,conn);
myCommand.Parameters.Add("@imgdata",SqlDbType.Image).Value = b;
myCommand.ExecuteNonQuery();
}
catch(Exception ex)
{
Log.Write("",ex.Message + " 语句为: " + strSql,System.Diagnostics.EventLogEntryType.Error,1);
}
finally
{
conn.Close();
}
}看看是否对你有帮助。
解决方案 »
- listView设置了OwnerDraw = true,怎样能制定列中生成一列checkBox,并响应复选?
- c#怎样能在textBox中动态显示串口接收到的数据
- 新人请教configurationmanger.appsetting的相关问题
- 奇怪的事情 怎么回事啊?
- 【交流】1个人累死累活赶完项目,老板加班费,分红一字不提,先要源代码!郁闷
- C#的SQL高手们帮忙看看!
- 点击DataGrid的一个超链接,跳转到一个新的页面,如何把选中的那一行数据传到新的页面?在线等!!
- 怎么在架设ftp
- c#中如何判断读取后文本文档中的回车
- 请问怎样用C#写一个系统服务进程?
- 关于数据库连接的释放
- 寻求一个解决方案,急!!!
System.Text.Encoding.GetEncoding("GB2312").GetBytes(str);
把byte[] 转化成字符串:
System.Text.Encoding.GetEncoding("GB2312").GetString(b)
--〉
System.Text.Encoding.GetEncoding("GB2312").GetBytes(str,0,str.Length,b,0)