Sir,
Here is my code please tell me where I am wrong as I want to show my image with other details in asp datagridview.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" >
<Columns>
<asp:BoundField DataField = "ID" HeaderText = "ID" />
<asp:BoundField DataField = "Fname" HeaderText = "Fname" />
<asp:BoundField DataField = "Lname" HeaderText = "Lname" />
<asp:BoundField DataField = "City" HeaderText = "City" />
<asp:BoundField DataField = "Add" HeaderText = "Add" />
<asp:BoundField DataField = "Adddate" HeaderText = "Adddate" />
<asp:ImageField DataImageUrlField = "ID"
DataImageUrlFormatString = "ImageVB.aspx?ImageID={0}"
ControlStyle-Width = "100" ControlStyle-Height = "100"
HeaderText = "Preview Image"/>
</Columns>
</asp:GridView>
---------------------
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
Dim strQuery As String = "select ID,FName,LName,[Add],City,Image,Adddate from prakashkaur.dbo.PersonDetail "
Dim cmd As SqlCommand = New SqlCommand(strQuery, myConnection)
If myConnection.State = ConnectionState.Closed Then
myConnection.Open()
End If
Dim adp As SqlDataAdapter = New SqlDataAdapter(cmd)
Dim ds As DataSet = New DataSet
adp.Fill(ds)
Dim dt As DataTable
dt = ds.Tables(0)
'
GridView1.DataSource = dt
GridView1.DataBind()
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
Sir,
Here is my code please tell me where I am wrong as I want to show my image with other details in asp datagridview.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" >
<Columns>
<asp:BoundField DataField = "ID" HeaderText = "ID" />
<asp:BoundField DataField = "Fname" HeaderText = "Fname" />
<asp:BoundField DataField = "Lname" HeaderText = "Lname" />
<asp:BoundField DataField = "City" HeaderText = "City" />
<asp:BoundField DataField = "Add" HeaderText = "Add" />
<asp:BoundField DataField = "Adddate" HeaderText = "Adddate" />
<asp:ImageField DataImageUrlField = "ID"
DataImageUrlFormatString = "ImageVB.aspx?ImageID={0}"
ControlStyle-Width = "100" ControlStyle-Height = "100"
HeaderText = "Preview Image"/>
</Columns>
</asp:GridView>
---------------------
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
Dim strQuery As String = "select ID,FName,LName,[Add],City,Image,Adddate from prakashkaur.dbo.PersonDetail "
Dim cmd As SqlCommand = New SqlCommand(strQuery, myConnection)
If myConnection.State = ConnectionState.Closed Then
myConnection.Open()
End If
Dim adp As SqlDataAdapter = New SqlDataAdapter(cmd)
Dim ds As DataSet = New DataSet
adp.Fill(ds)
Dim dt As DataTable
dt = ds.Tables(0)
'
GridView1.DataSource = dt
GridView1.DataBind()
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub