file = Request.QueryString["word"];
file = Server.MapPath(file);
if( !File.Exists(file) )
{
Response.Write("没找到该文件");
Response.End;
}
FileStream fs = new FileStream(file, FileMode.Open, FileAccess.Read);
byte[] bt = new byte[fs.Length];
fs.Read( bt, 0, fs.Length );
fs.Close();//插入数据库中
OleDbConnection con = new OleDbConnectin("连接字符串");
OleDbCommand cmd = con.CreateCommand();
cmd.CommandText = "Insert into [FILE] (FileData) Values (@FileData)";
cmd.Parameters.Add("@FileData",OleDbType.Binary).Value = bt;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
file = Server.MapPath(file);
if( !File.Exists(file) )
{
Response.Write("没找到该文件");
Response.End;
}
FileStream fs = new FileStream(file, FileMode.Open, FileAccess.Read);
byte[] bt = new byte[fs.Length];
fs.Read( bt, 0, fs.Length );
fs.Close();//插入数据库中
OleDbConnection con = new OleDbConnectin("连接字符串");
OleDbCommand cmd = con.CreateCommand();
cmd.CommandText = "Insert into [FILE] (FileData) Values (@FileData)";
cmd.Parameters.Add("@FileData",OleDbType.Binary).Value = bt;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
我上面的代码是把服务器上的文件传到数据库中,不是客户端文件!
是不可以的,还用没有其它的方法??