把RichTextBox中的文本保存到Sql Server中（C#）[转载]

最新推荐文章于 2022-08-29 02:05:02 发布

dahuzizyd

最新推荐文章于 2022-08-29 02:05:02 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： .NET相关文章标签： sql server c# null rtf exception stream

本文链接：https://blog.youkuaiyun.com/dahuzizyd/article/details/53631

.NET相关专栏收录该内容

73 篇文章

订阅专栏

本文展示了使用C#在SQL Server数据库中进行RTF数据读写的代码示例。保存部分将RichTextBox内容保存到临时文件，再将文件内容存入数据库；读取部分从数据库中读取RTF数据并显示在RichTextBox中，同时处理了异常情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

原文地址：http://www.developer.com/net/net/article.php/11087_3373951_1

保存：

private void btnSave_Click(object sender, System.EventArgs e)
  {

   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 btnLoad_Click(object sender, System.EventArgs e)
{
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();
   }

}