private int WriteToDB(string strName, string strType, ref byte[] Buffer)
{
int nFileID = 0;
OleDbConnection dbConn = new OleDbConnection(GetConnectionString());
OleDbDataAdapter dbAdapt = new OleDbDataAdapter("SELECT * FROM tblFile", dbConn);
dbAdapt.MissingSchemaAction = MissingSchemaAction.AddWithKey;
OleDbCommandBuilder dbCB = new OleDbCommandBuilder(dbAdapt);
dbConn.Open();
DataSet dbSet = new DataSet();
dbAdapt.Fill(dbSet, "tblFile");
DataTable dbTable = dbSet.Tables["tblFile"];
DataRow dbRow = dbTable.NewRow();
dbRow["FileName"] = strName;
dbRow["FileSize"] = Buffer.Length;
dbRow["ContentType"] = strType;
dbRow["FileData"] = Buffer;
dbTable.Rows.Add(dbRow);
dbAdapt.Update(dbSet, "tblFile");
if( !dbRow.IsNull("FileID") ) nFileID = (int)dbRow["FileID"];
dbConn.Close();
return nFileID;
}
{
int nFileID = 0;
OleDbConnection dbConn = new OleDbConnection(GetConnectionString());
OleDbDataAdapter dbAdapt = new OleDbDataAdapter("SELECT * FROM tblFile", dbConn);
dbAdapt.MissingSchemaAction = MissingSchemaAction.AddWithKey;
OleDbCommandBuilder dbCB = new OleDbCommandBuilder(dbAdapt);
dbConn.Open();
DataSet dbSet = new DataSet();
dbAdapt.Fill(dbSet, "tblFile");
DataTable dbTable = dbSet.Tables["tblFile"];
DataRow dbRow = dbTable.NewRow();
dbRow["FileName"] = strName;
dbRow["FileSize"] = Buffer.Length;
dbRow["ContentType"] = strType;
dbRow["FileData"] = Buffer;
dbTable.Rows.Add(dbRow);
dbAdapt.Update(dbSet, "tblFile");
if( !dbRow.IsNull("FileID") ) nFileID = (int)dbRow["FileID"];
dbConn.Close();
return nFileID;
}
解决方案 »
- 关于"否决的"方法
- 如何给DataGridView的RowHeader加右键菜单
- 关于C#调用C++ DLL 回调函数的问题
- 利用EXCELL导出数据
- .NET数据库对象化如何操作
- tablelayoutpanel控件错误
- Power Designer是什么意思
- 用C#2.0上 FTPWebRequest类 做的FTP小程序 可以上传下载其他FTP服务器(Linux,Unix)下的文件吗?
- 学习net 如何进一步提高 请教专家们
- C#中的问题 请各位帮忙解释一下 谢谢了
- 可怜,从C#转会C++开发!呜呜~~~
- 请问比如有两个变量(int) a,b,且a=b(把b的值付给a) ..怎么才能让以后b变化的时候a保持不变..谢谢..急
能把你的源代码发我一份吗?我现在同时也需要做一个类似的。
谢谢