private void save()
{
FileStream stream = null;
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
richTextBox1.SaveFile( "temp.rtf" );
stream = new FileStream("temp.rtf", FileMode.Open, FileAccess.Read);
int size = Convert.ToInt32(stream.Length);
Byte[] rtf = new Byte[size];
stream.Read(rtf, 0, size);
conn = new SqlConnection("Database=Northwind;Integrated Security=true;");
conn.Open();
cmd = new SqlCommand("UPDATE Employees SET Photo=@Photo WHERE EmployeeID=1", conn);
SqlParameter paramRTF = new SqlParameter("@Photo", SqlDbType.Image, rtf.Length, ParameterDirection.Input, false, 0,0,null, DataRowVersion.Current, rtf);
cmd.Parameters.Add(paramRTF); int rowsUpdated = Convert.ToInt32(cmd.ExecuteNonQuery());
MessageBox.Show(String.Format("{0} rows updated", rowsUpdated));
}
catch(Exception ex) { MessageBox.Show(ex.Message); }
finally
{
if ( stream != null ) stream.Close();
if (cmd != null ) cmd.Parameters.Clear();
if (conn != null) conn.Close();
}
}
private void Get()
{
richTextBox1.Clear();
SqlConnection cn = null; SqlCommand cmd = null;
SqlDataReader reader = null;
try
{
cn = new SqlConnection("Database=Northwind;Integrated Security=true;");
cn.Open(); cmd = new SqlCommand("SELECT Photo FROM Employees WHERE EmployeeID=1", cn);
reader = cmd.ExecuteReader(); reader.Read();
if (reader.HasRows)
{
if (!reader.IsDBNull(0))
{
Byte[] rtf = new Byte[Convert.ToInt32((reader.GetBytes(0, 0, null, 0, Int32.MaxValue)))];
long bytesReceived = reader.GetBytes(0, 0, rtf, 0, rtf.Length);
ASCIIEncoding encoding = new ASCIIEncoding();
richTextBox1.Rtf = encoding.GetString(rtf, 0, Convert.ToInt32(bytesReceived));
}
}
}
catch(Exception ex) { MessageBox.Show(ex.Message); }
finally
{
if (reader != null ) reader.Close();
if (cn != null ) cn.Close();
}
}
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列:向量存储与相似性搜索在 .NET 中的实现
· 基于Microsoft.Extensions.AI核心库实现RAG应用
· Linux系列:如何用heaptrack跟踪.NET程序的非托管内存泄露
· 开发者必知的日志记录最佳实践
· TypeScript + Deepseek 打造卜卦网站:技术与玄学的结合
· Manus的开源复刻OpenManus初探
· AI 智能体引爆开源社区「GitHub 热点速览」
· 三行代码完成国际化适配,妙~啊~
· .NET Core 中如何实现缓存的预热?