refdoc資料庫

A. 如何將txt,doc等文件以二進制形式保存在資料庫中

private int WriteToDB(string strName, string strType, ref byte[] Buffer) { int nFileID = 0; // Create connection OleDbConnection dbConn = new OleDbConnection(GetConnectionString()); // Create Adapter OleDbDataAdapter dbAdapt = new OleDbDataAdapter("SELECT * FROM tblFile", dbConn); // We need this to get an ID back from the database dbAdapt.MissingSchemaAction = MissingSchemaAction.AddWithKey; // Create and initialize CommandBuilder OleDbCommandBuilder dbCB = new OleDbCommandBuilder(dbAdapt); // Open Connection dbConn.Open(); // New DataSet DataSet dbSet = new DataSet(); // Populate DataSet with data dbAdapt.Fill(dbSet, "tblFile"); // Get reference to our table DataTable dbTable = dbSet.Tables["tblFile"]; // Create new row DataRow dbRow = dbTable.NewRow(); // Store data in the row dbRow["FileName"] = strName; dbRow["FileSize"] = Buffer.Length; dbRow["ContentType"] = strType; dbRow["FileData"] = Buffer; // Add row back to table dbTable.Rows.Add(dbRow); // Update data source dbAdapt.Update(dbSet, "tblFile"); // Get newFileID if( !dbRow.IsNull("FileID") ) nFileID = (int)dbRow["FileID"]; // Close connection dbConn.Close(); // Return FileID return nFileID; } 寫入庫。 private void ShowTheFile(int FileID) { // Define SQL select statement string SQL = "SELECT FileSize, FileData, ContentType FROM tblFile WHERE FileID = " + FileID.ToString(); // Create Connection object OleDbConnection dbConn = new OleDbConnection(GetConnectionString()); // Create Command Object OleDbCommand dbComm = new OleDbCommand(SQL, dbConn); // Open Connection dbConn.Open(); // Execute command and receive DataReader OleDbDataRea

B. sql資料庫怎麼導入word文檔

一、准備工作

首先請確認服務端已經安裝了Office Word(以下將以Office XP為例)，操作系統為win2000或XP，並且已配置好.NET的運行環境及安裝VS.NET C#開發環境後，我們就可以打開VS.NET，並新建一個Visual C#項目ASP.NET Web應用程序，位置為「」。(如圖一)

二、引用Word對象庫文件

要操作Word，我們就需要Word的對象庫文件「MSWORD.OLB」(word 2000為MSWORD9.OLB)，通常安裝了Office Word後，你就可以在office安裝目錄的Office10文件夾下面找到這個文件，當我們將這個文件引入到項目後，我們就可以在源碼中使用各種操作函數來操作Word。具體做法是打開菜單欄中的項目添加引用瀏覽，在打開的「選擇組件」對話框中找到MSWORD.OLB後按確定即可引入此對象庫文件，vs.net將會自動將庫文件轉化為DLL組件，這樣我們只要在源碼中創建該組件對象即可達到操作Word的目的！

三、Webform1.aspx.cs代碼

完成添加引用後，MSWORD.OLB已經轉化為相關DLL文件並放置於項目的BIN目錄下了，這樣我們只需在源碼中創建該對象，並使用word庫文件內置的操作函數即可輕松實現操作Word，Webform1.aspx.cs源碼請參見

五、web.config設置

web.config文件還需添加一句 identity impersonate="true"/以啟用模擬身份，因為默認ASPNET這個用戶是沒有許可權訪問Word.ApplicationClass()，當啟用模擬身份後所有頁面將會使用匿名Internet用戶帳戶(IUSR_machinename)這個用戶名的許可權執行，這樣我們就能成功訪問Word.ApplicationClass()並在ASP.NET中操作Word！

//傳文檔所在路徑返迴文檔內容
publicstringDoc2Text(stringdocFileName)
{
//實例化COM
Microsoft.Office.Interop.Word.ApplicationClasswordApp=newMicrosoft.Office.Interop.Word.ApplicationClass();
objectfileobj=docFileName;
objectnullobj=System.Reflection.Missing.Value;
//打開指定文件（不同版本的COM參數個數有差異，一般而言除第一個外都用nullobj就行了）
Microsoft.Office.Interop.Word.Documentdoc=wordApp.Documents.Open(reffileobj,refnullobj,refnullobj,
refnullobj,refnullobj,refnullobj,
refnullobj,refnullobj,refnullobj,
refnullobj,refnullobj,refnullobj,refnullobj,refnullobj,refnullobj,refnullobj
);
//取得doc文件中的文本
stringoutText=doc.Content.Text;
//關閉文件
doc.Close(refnullobj,refnullobj,refnullobj);
//關閉COM
wordApp.Quit(refnullobj,refnullobj,refnullobj);
//返回
returnoutText;
}

在讀取的時候會有損壞的文件 和被加密的文件等問題 總之C#和office的兼容性不太好

別忘了要引用word的dll

引用文件夾 右鍵添加引用 在組件里找Microsoft.Office.Interop.Word

讀出了word文檔再把它寫入sqlserver資料庫就可以了.

C. 微信公眾平台怎麼將收到的消息往資料庫里邊傳

java">///<summary>
///接收用戶消息
///iftrue
///2014-07-08
///</summary>
publicclassReceive
{
publicdelegateModels.Send_Msgdelegate_SendMsg(stringmsgType);
publicdelegatevoiddelegate_RececiveHandler(Models.Receive_Msgmodel,refstringmsg);

///<summary>
///獲取消息對象並且回復消息(需要根據強制轉換成需要的實體類)
///</summary>
///<paramname="context">上下文</param>
///<paramname="getSendMsg">獲取回復消息的方法</param>
///<paramname="receiveHandler">處理接收消息的方法（如：持久化資料庫）</param>
///<paramname="msg">錯誤信息</param>
///<returns></returns>
publicModels.Receive_MsgGetReceiveMsgAndReply(HttpContextcontext,delegate_SendMsggetSendMsg,delegate_RececiveHandlerreceiveHandler,refstringmsg)
{
if(context==null)
returnnull;
try
{
string_xml=newHttpHelper().PostInput(context.Request);
if(string.IsNullOrEmpty(_xml))
returnnull;
XmlDocumentdoc=newXmlDocument();
doc.LoadXml(_xml);
XmlElementelement=doc.DocumentElement;
Models.Receive_Msgmodel=GetReceiveModel(element);
//發送被動響應消息
Models.Send_MsgsendModel=getSendMsg(model.MsgType);
if(sendModel!=null)
{
sendModel.ToUserName=model.FromUserName;
sendModel.FromUserName=model.ToUserName;
Sendsend=newSend();
stringstrSend=send.Send_Msg<Models.Send_Msg>(sendModel,refmsg);
if(!string.IsNullOrEmpty(strSend))
{
context.Response.Output.Write(strSend);
}
}
//調用消息處理方法
try
{
receiveHandler(model,refmsg);
}
catch(Exceptionex)
{
msg="receiveHandler異常："+ex.Message;
}
returnmodel;
}
catch(Exceptionex)
{
msg=ex.Message;
returnnull;
}
}

///<summary>
///獲取消息對象直接回復空串(需要根據MsgType強制轉換成需要的實體類)
///</summary>
///<paramname="context">上下文</param>
///<paramname="getSendMsg">獲取回復消息的方法</param>
///<paramname="receiveHandler">處理接收消息的方法（如：持久化資料庫）</param>
///<paramname="msg">錯誤信息</param>
///<returns></returns>
publicModels.Receive_MsgGetReceiveMsg(HttpContextcontext,delegate_RececiveHandlerreceiveHandler,refstringmsg)
{
if(context==null)
returnnull;
try
{
//直接回復空串，避免騰訊重復發送
context.Response.Output.Write("");
string_xml=newHttpHelper().PostInput(context.Request);
if(string.IsNullOrEmpty(_xml))
returnnull;
XmlDocumentdoc=newXmlDocument();
doc.LoadXml(_xml);
XmlElementelement=doc.DocumentElement;
Models.Receive_Msgmodel=GetReceiveModel(element);

//調用消息處理方法
try
{
receiveHandler(model,refmsg);
}
catch(Exceptionex)
{
msg="receiveHandler異常："+ex.Message;
}
returnmodel;
}
catch(Exceptionex)
{
msg=ex.Message;
returnnull;
}
}

///<summary>
///解析XML，轉換為實體
///</summary>
///<paramname="element"></param>
///<returns></returns>
privateModels.Receive_MsgGetReceiveModel(XmlElementelement)
{
Models.Receive_Msgmodel=null;
stringmsgType=element.SelectSingleNode("MsgType").InnerText;
switch(msgType)
{
caseMsgType.text:model=newModels.Receive_Text();break;
caseMsgType.image:model=newModels.Receive_Image();break;
caseMsgType.voice:model=newModels.Receive_Voice();break;
caseMsgType.video:model=newModels.Receive_Video();break;
caseMsgType.location:model=newModels.Receive_Location();break;
caseMsgType.link:model=newModels.Receive_Link();break;
caseMsgType.events:model=GetEventModel(element.SelectSingleNode("Event").InnerText,element.SelectSingleNode("EventKey")==null?"":element.SelectSingleNode("EventKey").InnerText);break;
}
try
{
foreach(System.Reflection.PropertyInfopinmodel.GetType().GetProperties())
{
if(p.Name!="Xml")
{
p.SetValue(model,element.SelectSingleNode(p.Name).InnerText,null);
}
else
{
p.SetValue(model,element.OuterXml,null);
}
}
}
catch(Exceptionex)
{
throwex;
}
returnmodel;
}

///<summary>
///獲取事件對象
///</summary>
///<paramname="evt">事件類型</param>
///<paramname="eventKey">事件KEY值</param>
///<returns></returns>
privateModels.Receive_MsgGetEventModel(stringevt,stringeventKey)
{
Models.Receive_Msgmodel=null;
switch(evt)
{
caseEvent.subscribe:
if(string.IsNullOrEmpty(eventKey))
{
model=newModels.Receive_Event();
}
else
{
model=newModels.Receive_Event_Scan();
}
break;
caseEvent.unsubscribe:
model=newModels.Receive_Event();
break;
caseEvent.scan:
model=newModels.Receive_Event_Scan();
break;
caseEvent.location:
model=newModels.Receive_Event_Location();
break;
caseEvent.click:
model=newModels.Receive_Event_Click();
break;
caseEvent.view:
model=newModels.Receive_Event_View();
break;
}
returnmodel;
}
}