HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create("http://c.csdn
.net/bbs/t/5/i/pic_logo.gif");
try
{
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream sm = response.GetResponseStream();
MemoryStream ms=new MemoryStream();
byte[] buffer = new byte[4096];
int len;
len = sm.Read(buffer, 0, 4096);
while (len>0)
{
ms.Write(buffer, 0, len);
len=sm.Read(buffer, 0, 4096);
}
// 创建连接
SqlConnection conn=new SqlConnection(ConnectionString);
SqlCommand com=conn.CreateCommand();
com.CommandText="Update 表 Set [图片]=@F Where ID='0001'";
com.CommandType=CommandType.Text;
SqlParameter sp=new SqlParameter("@F",SqlDbType.Image,ms.GetBuffer().Length,ParameterDirection.Input,false,0,0,null,DataRowVersion.Current,ms.GetBuffer());
com.Parameters.Add(sp);
com.ExecuteNonQuery();
conn.Close();
}
catch (WebException ex)
{
if (ex.Status == WebExceptionStatus.NameResolutionFailure)
{
//域名无法解析
}
}
try
{
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream sm = response.GetResponseStream();
MemoryStream ms=new MemoryStream();
byte[] buffer = new byte[4096];
int len;
len = sm.Read(buffer, 0, 4096);
while (len>0)
{
ms.Write(buffer, 0, len);
len=sm.Read(buffer, 0, 4096);
}
// 创建连接
SqlConnection conn=new SqlConnection(ConnectionString);
SqlCommand com=conn.CreateCommand();
com.CommandText="Update 表 Set [图片]=@F Where ID='0001'";
com.CommandType=CommandType.Text;
SqlParameter sp=new SqlParameter("@F",SqlDbType.Image,ms.GetBuffer().Length,ParameterDirection.Input,false,0,0,null,DataRowVersion.Current,ms.GetBuffer());
com.Parameters.Add(sp);
com.ExecuteNonQuery();
conn.Close();
}
catch (WebException ex)
{
if (ex.Status == WebExceptionStatus.NameResolutionFailure)
{
//域名无法解析
}
}