http://expert.csdn.net/Expert/TopicView1.asp?id=2294193
解决方案 »
- c#调用webservise 的问题
- 关闭模式窗体
- 寻一个数字进位方法
- 请问一个简单问题,关于值类型和引用类型存储问题
- 建立treeView后,使用indexof(treenode)总是返回-1??
- C#2005现在市面或网上的是真正的微软发布的正式版吗?
- C# 的设置特性的作用,列举举例 即给分!
- 关于OdbcParameter的问题,请各位高手进来帮忙看一下!
- winform窗体在设计器内无法正常显示,但是运行阶段却正常,大家帮看下?
- 怎样得到 dataReader 返回的数据集的记录行数?
- ORACLE下的CLOB 和 BLOB可以通过ado.net传输并且向数据库更新马,感谢提供代码。。
- 如何消除窗体切换带来的屏幕闪动.
private void Button2_Click(object sender, System.EventArgs e)
{
//将图片并保存到数据库中
FileStream fs = new FileStream(Server.MapPath("") + "/temp.jpg",FileMode.Open);
byte[] b = new Byte[fs.Length];
fs.Read(b,0,(int)fs.Length);
fs.Close(); SqlConnection sc = new SqlConnection("data source=wenyong;initial catalog=testdb;user id=sa");
sc.Open(); SqlCommand scd = new SqlCommand("update Test set test_image=@image where test_name='wenyong'",sc);
scd.Parameters.Add("@image",b);
scd.ExecuteNonQuery();
}
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'保存,bmp1为一BitMap型对象,并已经装入图形
Dim ms As MemoryStream = New MemoryStream
bmp1.Save(ms, Imaging.ImageFormat.Png)
Dim b() As Byte = ms.ToArray
ms.Close()
Dim sc As SqlConnection = New SqlConnection("Integrated Security=SSPI;server=(local);database=test")
sc.Open()
Dim scd As SqlCommand = New SqlCommand("update test01 set test_image=@image where test_name='twg'", sc)
scd.Parameters.Add("@image", b)
scd.ExecuteNonQuery()
sc.Close()
sc.Dispose()
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
'读取
Dim sc As SqlConnection = New SqlConnection("Integrated Security=SSPI;server=(local);database=test")
sc.Open()
Dim scd As SqlCommand = New SqlCommand("select test_name,test_image from test01 where test_name='twg'", sc)
Dim da As New SqlDataAdapter(scd)
Dim ds = New DataSet
da.Fill(ds, "test01")
If Not IsDBNull(ds.Tables("test01").Rows(0)("test_image")) Then
Dim b As Byte() = CType(ds.Tables("test01").Rows(0)("test_image"), Byte())
PictureBox3.Image = Image.FromStream(New MemoryStream(b), True)
End If
sc.Close()
sc.Dispose()
End Sub