34,590
社区成员
发帖
与我相关
我的任务
分享
public void CreateMySqlCommand()
{
SqlCommand myCommand = new SqlCommand();
myCommand.CommandTimeout = 15;--设置这里
myCommand.CommandType = CommandType.Text;
}
public void show()
{
string ss = Request.QueryString["id"].ToString();
string s3 = "select * from imgpic where id=" + ss;
MySqlCommand comm = new MySqlCommand(s3, conn);
conn.Open();
MySqlDataReader dr = comm.ExecuteReader(CommandBehavior.CloseConnection);
while(dr.Read())
{
Response.Clear();
Response.ClearContent();
Response.BinaryWrite((byte[])dr["myimg"]);//读取
}
Response.End();
conn.Close();
}
}
RuntimeObject.DB.Open();
DataSet ds = RuntimeObject.DB.exeSqlForDataSet(SqlBuilder.GetSelect("SC_Upgrade",
"filename,filesize,filelastwritetime"));
RuntimeObject.DB.Close();
DataTable dt=ds.Tables[0];
foreach(DataRow dr in dt.Rows)
{
string filename = dr["filename"].ToString().Trim();
long filesize = Convert.ToInt64(dr["filesize"]);
DateTime filelastwritetime = Convert.ToDateTime(dr["filelastwritetime"]);
FileInfo fi = new FileInfo(path + @"\" + filename);
if ((!fi.Exists) || fi.Length != filesize || fi.LastWriteTime != filelastwritetime)
{
RuntimeObject.DB.Open();
object objx = RuntimeObject.DB.exeSqlForOneVal(SqlBuilder.GetSelect("SC_Upgrade", "filedata"
, new FilterParameter("filename", filename)));
RuntimeObject.DB.Close();
byte[] filedata = (byte[])objx;
if (fi.Exists) fi.Delete();
FileStream fs;
fs = fi.Create();
fs.Write(filedata, 0, filedata.Length);
fs.Close();
fi.LastWriteTime = filelastwritetime;
}
}
ZipInputStream lo_Zip = new ZipInputStream(lo_Stream);
lo_Zip.GetNextEntry();
string lo_Rst = lo_Zip;
--写个过程调试一下
create proc sp_test
as
select filedata from SC_Upgrade where filename='myexe.exe'
go
然后在网页调用:
exec sp_test --看看什么情况