How can I get record from gridview

HI,

In the gridview:





                    Text="" CommandArgument='<%# Eval("ID") %>' />


In the Gridview Rowcommand Event write this

int Idvalue = Convert.ToInt32(e.CommandArgument);
if(e.commandName==linkRetrieve)
{
Fetch_records(Idvalue);
}

    private void Fetch_records(string value)
    {
        string selectquery = "";
        selectquery = "select ID, UserName, Email_Id, State FROM Registration where ID=" + value;
        SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["SqlServer_value"]);

        SqlCommand sqlcomm = new SqlCommand();
        sqlcomm = sqlcon.CreateCommand();
        sqlcomm.CommandType = CommandType.Text;
        sqlcomm.CommandText = selectquery;
        sqlcon.Open();
        SqlDataReader sqlred = null;
        sqlred = sqlcomm.ExecuteReader();

        if (sqlred.Read())
        {
            if (sqlred["UserName"] != null)
            {
                txtName.Text = sqlred["UserName"].ToString();
            }
            if (sqlred["Email_Id"] != null)
            {
                txtEmailId.Text = sqlred["Email_Id"].ToString();
            }
            if (sqlred["State"] != null)
            {
                ddlState.SelectedValue = sqlred["State"].ToString();
            }
        }
        sqlcomm.Dispose();
        sqlcon.Close();
    }

web.config file

Hi Alok,
Here is your solution.

Note: - Here in gridview control add AutoGenerateSelectButton="true" AutoGenerateColumns="true".

Default.aspx code

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Pagetitle>

head>

<body>

<div>

<asp:GridView ID="GridView1" runat="server" AutoGenerateSelectButton="true" AutoGenerateColumns="true"

BackColor="#CCFFCC" Font-Bold="False" ForeColor="Maroon">

asp:GridView>

<br />

<asp:Label ID="lb1" runat="server" Text="ID : " Font-Bold="True" Width="100px">asp:Label>

<asp:Label ID="lbl_id" runat="server" ForeColor="#CC3300">asp:Label>

<br />

<asp:Label ID="lb3" runat="server" Text="NAME : " Font-Bold="True"

Width="100px">asp:Label>

<asp:Label ID="lbl_name" runat="server" ForeColor="#CC3300">asp:Label>

<br />

<asp:Label ID="lb5" runat="server" Text="ADDRESS : " Font-Bold="True"

Width="100px">asp:Label>

<asp:Label ID="lbl_address" runat="server" ForeColor="#CC3300">asp:Label>

<br />

<asp:Label ID="lb7" runat="server" Text="MARK : " Font-Bold="True"

Width="100px">asp:Label>

<asp:Label ID="lbl_marks" runat="server" ForeColor="#CC3300">asp:Label>

<br />

<asp:Label ID="lb9" runat="server" Text="YEAR : " Font-Bold="True"

Width="100px">asp:Label>

<asp:Label ID="lbl_year" runat="server" ForeColor="#CC3300">asp:Label>

div>

form>

body>

html>

Default.aspx.vb code

Imports System.Data.SqlClient

Imports System.Data

Partial Class _Default

Inherits System.Web.UI.Page

Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()

Dim con As New SqlConnection(strConnString)

Dim sqlda As SqlDataAdapter

Dim com As SqlCommand

Dim ds As DataSet

Dim str As String

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Not IsPostBack Then

bindgrid()

End If

End Sub

Sub bindgrid()

Try

con.Open()

str = "select * from student"

com = New SqlCommand(str, con)

sqlda = New SqlDataAdapter(com)

ds = New DataSet

sqlda.Fill(ds, "student")

GridView1.DataSource = ds

GridView1.DataMember = "student"

GridView1.DataBind()

con.Close()

Catch ex As Exception

Response.Write(ex.Message)

End Try

End Sub

Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.SelectedIndexChanged

Try

lbl_id.Text = GridView1.SelectedRow.Cells(1).Text

lbl_name.Text = GridView1.SelectedRow.Cells(2).Text

lbl_address.Text = GridView1.SelectedRow.Cells(3).Text

lbl_marks.Text = GridView1.SelectedRow.Cells(4).Text

lbl_year.Text = GridView1.SelectedRow.Cells(5).Text

Catch ex As Exception

Response.Write(ex.Message)

End Try

End Sub

End Class

Thanks
If this post helps you mark it as answer

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Prabhu Raja15y ago
Hi Alok,

I have attached Source Code Here. It will guide to Achieve your tasks.

----------------------------------------------------
If this post helps you, then mark this post as "Correct Answer"
0
Jiteendra Sampathirao15y ago
HI,

In the gridview:





                    Text="" CommandArgument='<%# Eval("ID") %>' />


In the Gridview Rowcommand Event write this

int Idvalue = Convert.ToInt32(e.CommandArgument);
if(e.commandName==linkRetrieve)
{
Fetch_records(Idvalue);
}

    private void Fetch_records(string value)
    {
        string selectquery = "";
        selectquery = "select ID, UserName, Email_Id, State FROM Registration where ID=" + value;
        SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["SqlServer_value"]);

        SqlCommand sqlcomm = new SqlCommand();
        sqlcomm = sqlcon.CreateCommand();
        sqlcomm.CommandType = CommandType.Text;
        sqlcomm.CommandText = selectquery;
        sqlcon.Open();
        SqlDataReader sqlred = null;
        sqlred = sqlcomm.ExecuteReader();

        if (sqlred.Read())
        {
            if (sqlred["UserName"] != null)
            {
                txtName.Text = sqlred["UserName"].ToString();
            }
            if (sqlred["Email_Id"] != null)
            {
                txtEmailId.Text = sqlred["Email_Id"].ToString();
            }
            if (sqlred["State"] != null)
            {
                ddlState.SelectedValue = sqlred["State"].ToString();
            }
        }
        sqlcomm.Dispose();
        sqlcon.Close();
    }

web.config file



0
Satyapriya Nayak15y ago
Hi Alok,
Here is your solution.

Note: - Here in gridview control add AutoGenerateSelectButton="true" AutoGenerateColumns="true".

Default.aspx code

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>Untitled Pagetitle>

head>

<body>

    <form id="form1" runat="server">

    <div>

     <asp:GridView ID="GridView1" runat="server" AutoGenerateSelectButton="true" AutoGenerateColumns="true"

        BackColor="#CCFFCC" Font-Bold="False" ForeColor="Maroon">

        <AlternatingRowStyle BackColor="#FFCC66" />

    asp:GridView>

    <br />

    <asp:Label ID="lb1" runat="server" Text="ID : " Font-Bold="True" Width="100px">asp:Label>

    <asp:Label ID="lbl_id" runat="server" ForeColor="#CC3300">asp:Label>

    <br />

    <br />

    <asp:Label ID="lb3" runat="server" Text="NAME : " Font-Bold="True"

        Width="100px">asp:Label>

    <asp:Label ID="lbl_name" runat="server" ForeColor="#CC3300">asp:Label>

    <br />

    <br />

    <asp:Label ID="lb5" runat="server" Text="ADDRESS : " Font-Bold="True"

        Width="100px">asp:Label>

    <asp:Label ID="lbl_address" runat="server" ForeColor="#CC3300">asp:Label>

    <br />

    <br />

    <asp:Label ID="lb7" runat="server" Text="MARK : " Font-Bold="True"

        Width="100px">asp:Label>

    <asp:Label ID="lbl_marks" runat="server" ForeColor="#CC3300">asp:Label>

    <br />

    <br />

    <asp:Label ID="lb9" runat="server" Text="YEAR : " Font-Bold="True"

        Width="100px">asp:Label>

    <asp:Label ID="lbl_year" runat="server" ForeColor="#CC3300">asp:Label>



    div>

   form>

body>

html>

Default.aspx.vb code

Imports System.Data.SqlClient

Imports System.Data

Partial Class _Default

    Inherits System.Web.UI.Page

    Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()

    Dim con As New SqlConnection(strConnString)

    Dim sqlda As SqlDataAdapter

    Dim com As SqlCommand

    Dim ds As DataSet

    Dim str As String

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        If Not IsPostBack Then

            bindgrid()

        End If

    End Sub

    Sub bindgrid()

        Try

            con.Open()

            str = "select * from student"

            com = New SqlCommand(str, con)

            sqlda = New SqlDataAdapter(com)

            ds = New DataSet

            sqlda.Fill(ds, "student")

            GridView1.DataSource = ds

            GridView1.DataMember = "student"

            GridView1.DataBind()

            con.Close()

        Catch ex As Exception

            Response.Write(ex.Message)

        End Try

    End Sub

    Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.SelectedIndexChanged

        Try

            lbl_id.Text = GridView1.SelectedRow.Cells(1).Text

            lbl_name.Text = GridView1.SelectedRow.Cells(2).Text

            lbl_address.Text = GridView1.SelectedRow.Cells(3).Text

            lbl_marks.Text = GridView1.SelectedRow.Cells(4).Text

            lbl_year.Text = GridView1.SelectedRow.Cells(5).Text

        Catch ex As Exception

            Response.Write(ex.Message)

        End Try

    End Sub
End Class

Thanks
If this post helps you mark it as answer
0