Hi arie.keren,
Please refer below sample.
HTML
<asp:GridView ID="grdTest" runat="server" AllowPaging="false" Width="100%" AutoGenerateColumns="False"
CellPadding="10" ForeColor="#333333" DataKeyNames="id">
<AlternatingRowStyle BackColor="#f7f7f7" ForeColor="Black" Font-Italic="false" />
<HeaderStyle CssClass="HeaderGrid" />
<RowStyle CssClass="IsiGrid" Wrap="TRUE" />
<Columns>
<asp:TemplateField HeaderText="No.">
<ItemTemplate>
<%# Container.DataItemIndex + 1 %>
</ItemTemplate>
<HeaderStyle Width="30px" HorizontalAlign="Center" />
<ItemStyle Width="30px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Pertanyaan">
<ItemTemplate>
<asp:Label ID="kode" runat="server" Text='<%#Eval("id") %>' Visible="false"></asp:Label>
<img alt="" src='<%#Eval("Path") %>' /><br />
<asp:RadioButton ID="rad1" runat="server" Text='<%#Eval("Name") %>' GroupName="A" /><br />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
Namespaces
C#
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
VB.Net
Imports System.Data.SqlClient
Imports System.Data
Code
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(constr))
{
using (SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM tblFilespath", conn))
{
DataTable dt = new DataTable();
sda.Fill(dt);
grdTest.DataSource = dt;
grdTest.DataBind();
}
}
}
}
VB.Net
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Using conn As SqlConnection = New SqlConnection(constr)
Using sda As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM tblFilespath", conn)
Dim dt As DataTable = New DataTable()
sda.Fill(dt)
grdTest.DataSource = dt
grdTest.DataBind()
End Using
End Using
End If
End Sub
Screenshot
