Hi edaadura,
Check this example. Now please take its reference and correct your code.
HTML
Default
<asp:GridView ID="GridView1" runat="server" BorderColor="White" BorderWidth="0px"
AutoGenerateColumns="false" GridLines="None">
<Columns>
<asp:TemplateField HeaderText="">
<ItemTemplate>
<%# Container.DataItemIndex + 1 %>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="50px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="">
<ItemTemplate>
<h3 class="h3">
<asp:HyperLink ID="label_soalan" runat="server" Text='<%# Eval("p_name")%>' NavigateUrl='<%# Eval("ID","~/Details.aspx?id={0}")%>'></asp:HyperLink></h3>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
Details
ID : <asp:Label ID="lblID" runat="server" Text=""></asp:Label><br />
soalan : <asp:Label ID="lblSoalan" runat="server" Text=""></asp:Label><br />
tajuk : <asp:Label ID="lblTajuk" runat="server" Text=""></asp:Label><br />
tarikh : <asp:Label ID="lblTarikh" runat="server" Text=""></asp:Label><br />
jawapan : <asp:Label ID="lblJawapan" runat="server" Text=""></asp:Label><br />
p_name : <asp:Label ID="lblP_name" runat="server" Text="Label"></asp:Label><br />
b_day : <asp:Label ID="lblB_day" runat="server" Text=""></asp:Label><br />
fax_no : <asp:Label ID="lblFax_no" runat="server" Text=""></asp:Label><br />
<asp:Image ID="Image1" runat="server" Width="180px" Height="120px" /><br />
Namespaces
C#
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
VB.Net
Imports System.Configuration
Imports System.Data
Imports System.Data.SqlClient
Code
C#
Default
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.BindGrid();
}
}
private void BindGrid()
{
string strcon = ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString;
using (SqlConnection con = new SqlConnection(strcon))
{
using (SqlCommand cmd = new SqlCommand("SELECT ID,p_name FROM DetailsE", con))
{
cmd.CommandType = CommandType.Text;
using (SqlDataAdapter sda = new SqlDataAdapter())
{
sda.SelectCommand = cmd;
DataTable dt = new DataTable();
sda.Fill(dt);
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
}
}
}
}
Details
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
string strcon = ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString;
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
using (SqlConnection con = new SqlConnection(strcon))
{
using (SqlCommand cmd = new SqlCommand("SELECT ID,soalan,tajuk,tarikh,jawapan,ap_img,p_name,b_day,fax_no FROM DetailsE", con))
{
con.Open();
cmd.Parameters.AddWithValue("@id", Request.QueryString["id"].ToString());
cmd.CommandType = CommandType.Text;
SqlDataReader sdr = cmd.ExecuteReader();
sdr.Read();
lblID.Text = sdr["ID"].ToString();
lblSoalan.Text = sdr["soalan"].ToString();
lblTajuk.Text = sdr["tajuk"].ToString();
lblTarikh.Text = Convert.ToDateTime(sdr["tarikh"]).ToString("dd/MM/yyyy");
lblJawapan.Text = sdr["jawapan"].ToString();
Image1.ImageUrl = sdr["ap_img"].ToString().Replace("~/", "").Replace("../", "");
lblP_name.Text = sdr["p_name"].ToString();
lblB_day.Text = Convert.ToDateTime(sdr["b_day"]).ToString("dd/MM/yyyy");
lblFax_no.Text = sdr["fax_no"].ToString();
con.Close();
}
}
}
}
}
VB.Net
Default
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
Me.BindGrid()
End If
End Sub
Private Sub BindGrid()
Dim strcon As String = ConfigurationManager.ConnectionStrings("ConStr").ConnectionString
Using con As SqlConnection = New SqlConnection(strcon)
Using cmd As SqlCommand = New SqlCommand("SELECT ID,p_name FROM DetailsE", con)
cmd.CommandType = CommandType.Text
Using sda As SqlDataAdapter = New SqlDataAdapter()
sda.SelectCommand = cmd
Dim dt As DataTable = New DataTable()
sda.Fill(dt)
Me.GridView1.DataSource = dt
Me.GridView1.DataBind()
End Using
End Using
End Using
End Sub
Details
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
Dim strcon As String = ConfigurationManager.ConnectionStrings("ConStr").ConnectionString
If Not String.IsNullOrEmpty(Request.QueryString("id")) Then
Using con As SqlConnection = New SqlConnection(strcon)
Using cmd As SqlCommand = New SqlCommand("SELECT ID,soalan,tajuk,tarikh,jawapan,ap_img,p_name,b_day,fax_no FROM DetailsE", con)
con.Open()
cmd.Parameters.AddWithValue("@id", Request.QueryString("id").ToString())
cmd.CommandType = CommandType.Text
Dim sdr As SqlDataReader = cmd.ExecuteReader()
sdr.Read()
lblID.Text = sdr("ID").ToString()
lblSoalan.Text = sdr("soalan").ToString()
lblTajuk.Text = sdr("tajuk").ToString()
lblTarikh.Text = Convert.ToDateTime(sdr("tarikh")).ToString("dd/MM/yyyy")
lblJawapan.Text = sdr("jawapan".ToString())
Image1.ImageUrl = sdr("ap_img").ToString().Replace("~/", "").Replace("../", "")
lblP_name.Text = sdr("p_name").ToString()
lblB_day.Text = Convert.ToDateTime(sdr("b_day")).ToString("dd/MM/yyyy")
lblFax_no.Text = sdr("fax_no").ToString()
con.Close()
End Using
End Using
End If
End If
End Sub
Screenshot
