在数据库中存储和显示图象(存储一)

新客网 XKER.COM 2004-12-21 来源：收藏本文

using System;using System.Data.SqlClient;using System.Data.SqlTypes;using System.IO;string imageFileLocation=“D:\images\”;string imageFilePrefix=“cereal“;int numberImageFiles=7;string imageFileType=“.gif“;int maxImageSize=10000;SqlConnection imageConnection=null;SqlCommand imageCommand=null;]//几个要用到的方法;void openConnection() { //create SqlConnection Object imageConnection=new SqlConnection(ConfigurationSettings.AppSettings[“wind“]); //open connection imageConnection.open(); }void closeConnection() { //close the connection imageConnection.Close(); }void createCommand(){imageCommand=new SqlCommand();imageCommand.Connection=imageConnection;}void executeCommand(string commandText){int commandResult;imageCommand.CommandText=commandText;commandResult=imageCommand.ExecuteNonQuery();}void createImageTable(){executeCommand(“IF EXISTS{“+“SELECT TABLE_NAME“+“FROM INFOEMATION_SCHEMA.TABLES“+“WHERE TABLE_NAME='imagetable'“+“) DROP TABLE imagetable“ );executeCommand(“CREATE TABLE imagetable(“+“imagefile NVARCHAR(20),“+“imagedata IMAGE“+ “)“ );}

上一篇：C++程序员容易犯的十个C#错误下一篇：我对C#中事件委托的通俗看法

【收藏】【评论】【推荐】【投稿】【打印】【关闭】