复制/// <summary> /// 写大字段内容 /// （新方法，中利B字2010.2.4） /// </summary> /// <param name="pDbConn"></param> /// <param name="strTable"></param> /// <param name="strBlobField"></param> /// <param name="strFile"></param> /// <param name="strWhereClause"></param> /// <returns></returns> publicbool WriteBlobField(System.Data.OleDb.OleDbConnection pDbConn,段存
string strTable, string strBlobField, string strFile, string strWhereClause) { if (strWhereClause == "") { returnfalse; } try { string strSQL = "UPDATE " + strTable + " SET " + strBlobField + " =:blob WHERE " + strWhereClause; OleDbCommand cmd = new OleDbCommand(strSQL, pDbConn); //无需说明类型 //cmd.Parameters.Add(new OleDbParameter("blob", SqlDbType.VarBinary)); // cmd.Parameters.AddWithValue("blob", SqlDbType.Binary); FileInfo fileInfo = new FileInfo(strFile); FileStream fsBlob = fileInfo.OpenRead();// new FileStream(strFile, FileMode.Open,FileAccess.Read); byte[] dataBlob = newbyte[fsBlob.Length];//问题1所在 fsBlob.Read(dataBlob, 0, System.Convert.ToInt32(fsBlob.Length));//问题2所在 fsBlob.Close(); //采用新的
云服务器提供商方法，
亿华云计算AddWithValue(); cmd.Parameters.AddWithValue("blob",视频数据
dataBlob); //cmd.Parameters["blob"].Value = dataBlob; int result = cmd.ExecuteNonQuery(); if (result < 1) { returnfalse; } } catch (Exception ex) { // MessageBox.Show(ex.Message, "写数据", MessageBoxButtons.OK); returnfalse; } returntrue; } /// <summary> /// 将字符串写成大字段内容 /// (2010.2.4 修改) /// </summary> /// <param name="pDbConn"></param> /// <param name="strTable"></param> /// <param name="strBlobField"></param> /// <param name="strBlobContent"></param> /// <param name="strWhereClause"></param> /// <returns></returns> publicbool WriteBlobField2(System.Data.OleDb.OleDbConnection pDbConn, string strTable, string strBlobField, string strBlobContent, string strWhereClause) { if (strWhereClause == "") { returnfalse; } try { string strSQL = "UPDATE " + strTable + " SET " + strBlobField + " =:blob " + "WHERE " + strWhereClause; OleDbCommand cmd = new OleDbCommand(strSQL, pDbConn); cmd.Parameters.Add(strBlobField, SqlDbType.Binary); // byte[] dataBlob = new byte[strBlobContent.Length]; byte[] dataBlob = System.Text.Encoding.Default.GetBytes(strBlobContent); cmd.Parameters["blob"].Value = dataBlob; int result = cmd.ExecuteNonQuery(); if (result < 1) { returnfalse; } } catch (Exception ex) { MessageBox.Show(ex.Message, "写数据", MessageBoxButtons.OK); returnfalse; } returntrue; } 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.73.74.75.76.77.78.79.80.81.82.83.84.85.86.87.88.89.90.91.92.93.94.95.96.97.
IT技术网