Openwrite如何導入圖片

❶ 如何在資料庫中同時保存文本和圖片

1. 向資料庫中保存不同類型的文件，和在資料庫中保存圖片是一樣的。就是向資料庫以byte形式存入

2. 向資料庫中保存不同類型的文件，和在資料庫中保存圖片是一樣的。就是向資料庫以byte形式存入

   

3. 然後就是寫入資料庫，代碼如下：

FileInfo fi = new FileInfo( txtFileName.Text );// Replace with your file name
if ( fi.Exists
{
byte[] bData = null;

int nNewFileID = 0;

// Read file data into buffer

using ( FileStream fs = fi.OpenRead() )
{

bData = new byte[fi.Length];

int nReadLength = fs.Read( bData,0, (int)(fi.Length) );

}

// Add file info into DB

string strQuery = "INSERT INTO FileInfo "

+ " ( FileName, FullName, FileData ) "

+ " VALUES "

+ " ( @FileName, @FullName, @FileData ) "

+ " SELECT @@IDENTITY AS 'Identity'";

SqlCommand sqlComm = new SqlCommand( strQuery, sqlConn );

sqlComm.Parameters.Add( "@FileName", fi.Name );

sqlComm.Parameters.Add( "@FullName", fi.FullName );

sqlComm.Parameters.Add( "@FileData", bData );
// Get new file ID

SqlDataReader sqlReader = sqlComm.ExecuteReader();

if( sqlReader.Read() )

{

nNewFileID = int.Parse(sqlReader.GetValue(0).ToString());

}
sqlReader.Close();
sqlComm.Dispose();

if( nNewFileID > 0 )
{
// Add new item in list view

ListViewItem itmNew = lsvFileInfo.Items.Add( fi.Name );

itmNew.Tag = nNewFileID;
}
}

4.而讀出的代碼如下：

// Get new file name

stringstrFullName =
dlgFBSave.SelectedPath;

if( strFullName[strFullName.Length - 1] != '//'
)

strFullName
+= @"/";

strFullName +=
lsvFileInfo.SelectedItems[0].Text;

stringstrQuery = "SELECT FileData FROM FileInfo
"

+
" WHERE FileID = " + lsvFileInfo.SelectedItems[0].Tag.ToString();

SqlDataAdapter
sqlDAdapter =newSqlDataAdapter(strQuery,sqlConn);

DataSet
sqlRecordSet =newDataSet();

byte[] bData =null;

//Get file data from DB

try

{

sqlDAdapter.Fill(
sqlRecordSet, "FileInfo" );

foreach( DataRow drinsqlRecordSet.Tables["FileInfo"].Rows)

{

if( dr["FileData"] != DBNull.Value )

bData
= (byte[] )dr["FileData"];

}

}

catch(SqlException sqlErr)

{

MessageBox.Show(
sqlErr.Message );

}

catch

{

MessageBox.Show(
"Failed to read data from DB!" );

}

sqlRecordSet.Dispose();

sqlDAdapter.Dispose();

if( bData !=null)

{

// Save file

FileInfo
fi =newFileInfo( strFullName
);

if( !fi.Exists )

{

//Create the file.

using(FileStream fs = fi.Create())

{

fs.Write(
bData, 0, bData.Length);

}

}

else

{

//Create the file.

using(FileStream fs =
fi.OpenWrite())

{

fs.Write(
bData, 0, bData.Length);

}

}

}