none
Change gridview field type RRS feed

  • Question

  • I'm a newbie in vb.net ! my code working to show my database data on GridView it's work fine but I want to change specific value to Image? my code :

    Dim img_c As String = "my image Url"
        Dim img_x As String
        Dim constr As String = ("my connection string")
        Dim con As New SqlConnection(constr)
        Dim cmd As New SqlCommand()
        cmd.CommandText = "SELECT * FROM Attendance"
        cmd.Connection = con
        Dim sda As New SqlDataAdapter(cmd)
        Dim dt As New DataTable()
        sda.Fill(dt)
        GridView1.DataSource = dt
        GridView1.DataBind()
        Dim ds As New DataSet
        For i As Integer = 1 To GridView1.Rows.Count - 2
            For s As Integer = 3 To GridView1.Columns.Count - 2
                If GridView1.Rows(i).Cells(s).text ="1" Then
                    GridView1.ImageField(img_c)
    
                End If
            Next
        Next

    my source:

    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
           CellPadding="4" DataKeyNames="std_num"
           Height="448px" Width="1352px" BackColor="White" BorderColor="#3366CC"
           BorderStyle="None" BorderWidth="1px" style="margin-right: 12px">
           <Columns>
               <asp:BoundField DataField="Total" HeaderText="totla" SortExpression="Total" >
               <HeaderStyle ForeColor="White" />
               </asp:BoundField>
               <asp:BoundField DataField="4" HeaderText="4" SortExpression="4"  >
                   <HeaderStyle ForeColor="White" />
               </asp:BoundField>
               <asp:BoundField DataField="3" HeaderText="3" SortExpression="3"  >
                   <HeaderStyle ForeColor="White" />
               </asp:BoundField>
               <asp:BoundField DataField="2" HeaderText="2" SortExpression="2"  >
                   <HeaderStyle ForeColor="White" />
               </asp:BoundField>
               <asp:BoundField DataField="1" HeaderText="1" SortExpression="1"  >
                   <HeaderStyle ForeColor="White" />
               </asp:BoundField>
               <asp:BoundField DataField="std_name" HeaderText="std_name"
                   SortExpression="std_name" >
                   <HeaderStyle ForeColor="White" />
               </asp:BoundField>
               <asp:BoundField DataField="std_num" HeaderText="std_num"
                   SortExpression="std_num" ReadOnly="True" >
                   <HeaderStyle ForeColor="White" />
               </asp:BoundField>
               <asp:BoundField DataField="No" HeaderText="No" SortExpression="No"
                   InsertVisible="False" ReadOnly="True" >
               <HeaderStyle ForeColor="White" />
               </asp:BoundField>
           </Columns>
           <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
           <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
           <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
           <RowStyle BackColor="White" ForeColor="Black" BorderColor="#333333"
               Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Middle" />
           <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
           <SortedAscendingCellStyle BackColor="#EDF6F6" />
           <SortedAscendingHeaderStyle BackColor="#0D4AC4" />
           <SortedDescendingCellStyle BackColor="#D6DFDF" />
           <SortedDescendingHeaderStyle BackColor="#002876" />
       </asp:GridView>

    my issue is change field to Image , there is no GridView image properties

    Wednesday, August 22, 2018 12:57 PM

All replies

  • For ASP.NET grid, ask in the following forum.

    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    Wednesday, August 22, 2018 1:36 PM