110,561
社区成员
发帖
与我相关
我的任务
分享
public string fnRec()
{
SqlConnection sqlcon = new SqlConnection("Data Source=007-324a07be4d8;User ID=sa;PWD=8812780;DataBase=db_ps");
string sqltopadcom = "select top 3* from tb_ps";
string _Url ="";
SqlCommand myda = new SqlCommand(sqltopadcom, sqlcon);
sqlcon.Open();
SqlDataReader dr = myda.ExecuteReader();
dr.open();
while (dr.Read())
{
_Url=dr["ps_img"].ToString();
}
dr.Close();
sqlcon.Close();
return _Url;
}
public byte[] getImage(string strSqlString)
{
SqlCommand sqlCmd = new SqlCommand(strSqlString, sqlConn);
byte[] imageData = null;
try
{
if (sqlConn.State == ConnectionState.Closed)
{
sqlConn.Open();
}
SqlDataReader sqlReader = sqlCmd.ExecuteReader();
while (sqlReader.Read())
{
imageData = (byte[])sqlReader.GetValue(0);
}
return imageData;
}
catch (SqlException) { }
finally
{
sqlConn.Close();
}
return null;
}