把RichTextBox中的文本保存到Sql Server中（C#）

新客网 XKER.COM 2004-08-14 来源： 收藏本文

保存：

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();
}

}

• ·身份证函数 查看身份证地区信息
• ·VS2008 第一次安装心得及使用
• ·ASP.NET 2.0跨网页提交的三法
• ·编程实例 WebGroupBox(Aspx控件)
• ·asp.net mvc脚手架代码生成工具
• ·用独立的DLL来存储图片(资源文件)
• ·ASP.NET中多国语言的实现方法
• ·实例 .net生成静态页方法总结
• ·ASP.NET控件学习笔记之ViewState
• ·用递归在TreeView价节点
• ·经验总结 关于.NET 中的Event机制
• ·.NET应用程序开发标准化(z)
• ·在DataTable中查询应该注意的问题
• ·LINQ 中调用存储过程自动绑定列名
• ·如何用.NET技术在线生成网站LOGO
• ·对于访问IIS元数据库失败的解决