作者:乔山办公网日期:
返回目录:word文档
把该文件当作图片处理,以二进制格式读入文件,然后存入数据库。具体方法图上有许多教程。
你哪能直百接度插入NSData类型问char *buffer=new char[1024*1024]; //要放入的答内容sqlite3_prepare( db, "insert into tb( ID, content) values( 10, ? )", -1, &stat, 0 );//准备版插入数权据sqlite3_bind_blob( stat, 1, buffer, strlen(buffer), NULL ...
以二进制方式读出来后组合成文件即可
protected void Button1_Click(object sender, EventArgs e)
{
//FileInfo thefile = new FileInfo(@7a64e58685e5aeb9336"D:\立项依据.doc");
FileStream fsDoc = File.OpenRead(@"D:\立项依据.doc");
DateTime dtnow = DateTime.Now;
string filename = dtnow.ToString("yyyyMMdd")+".doc";
byte[] buffer=new byte[fsDoc.Length];
fsDoc.Read(buffer,0,(int)fsDoc.Length);
conn.Open();
string sqlCmd = @"Insert into MyUploadTable(filename,filesize,filedata,ProjectID,IsAuditActivePage)
Values(@filename,@filesize,@filedata,@ProjectID,1)";
SqlCommand Cmd = new SqlCommand(sqlCmd,conn);
Cmd.Parameters.Add("@filename",SqlDbType.VarChar).Value=filename;
Cmd.Parameters.Add("@filesize",SqlDbType.BigInt).Value=fsDoc.Length;
Cmd.Parameters.Add("@filedata",SqlDbType.Image).Value=buffer;
Cmd.Parameters.Add("@ProjectID",SqlDbType.Int).Value=2;
Cmd.ExecuteNonQuery();
fsDoc.Close();
conn.Close();
}