开发者

how to retrieve an image from database using image URL and insert it in grid view in vb. net?

how to retrieve an image from database using image URL and insert it in grid view in vb. net ??

thats my data base table

i have 3 columns in table image (ID as int , imageName as varchar , imageURL as varchar(max) i want to insert the image in a grid view but when i run this code i only get the last image in my table everytime

thats my code:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'---------------------------------------------------------------------------
Dim dt As New DataTable()
Dim strConnString As [String] = System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString()
Dim strQuery As String = "select * from image"
D开发者_StackOverflow社区im con As New SqlConnection(strConnString)
Dim cmd As New SqlCommand(strQuery, con)
Dim sda As New SqlDataAdapter()
    cmd.CommandType = CommandType.Text
    cmd.Connection = con
    Try
        con.Open()
        sda.SelectCommand = cmd
        sda.Fill(dt)
        GridView1.DataSource = dt
        GridView1.DataBind()
    Catch ex As Exception
        Response.Write(ex.Message)
    Finally
        con.Close()
        sda.Dispose()
        con.Dispose()
    End Try
End Sub


you should have this column in the column definition of your GridView:

<asp:ImageField DataImageUrlField="PictureURL"></asp:ImageField>

where PictureURL is the name of the column which contains the image url.

here there is a full example directly from MSDN:

Displaying Images in a GridView Column

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜