How to find Particular Row Details of GridView Control in asp,net

Question

0.00/5 (No votes)

See more:

I have a Grid View Control, whenever the page loads all the available Data will display on my GridView and i place a Link Button on each row, now my problem is Whenever i Click on pay button the page will Redirect to another page by taking the details of that particular Row only. Below is my code....

ASP.NET

<asp:GridView ID="gvap" runat="server" AutoGenerateColumns="false" >
  <Columns>
  <asp:BoundField HeaderText="Course" DataField="course_name" />
  <asp:BoundField HeaderText="Start Date" DataField="start_date" />
  <asp:BoundField HeaderText="End Date" DataField="end_date" />
  <asp:BoundField HeaderText="Timings" DataField="timings" />
  <asp:BoundField HeaderText="Amount" DataField="amount" />
  <asp:TemplateField>
  <ItemTemplate>
  <asp:LinkButton runat="server" ID="lbtn" Text="Pay" PostBackUrl="~/EBS.aspx"></asp:LinkButton>
  </ItemTemplate>
  </asp:TemplateField>
  </Columns>
  </asp:GridView>

C#

protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Data Source=(local); Initial Catalog=123; User Id=sa; Password=123; Integrated Security=false";


        //Assigning Query
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = conn;
        cmd.CommandText = "select course_name , start_date , end_date, timings, amount from courses where start_date>=GETDATE()";
        cmd.CommandType = CommandType.Text;
        

        //Execute the COmmand
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.SelectCommand = cmd;
        DataSet ds = new DataSet();
        da.Fill(ds);
        gvap.DataSource = ds;
        gvap.DataBind();    
    }

Posted 27-Oct-13 19:52pm

Venkat Kumar chigulla

Add a Solution

Comments

[no name] 28-Oct-13 2:11am

remove navigate url in ur pay button, use row command event of grid view and fetch data of row from naming container... pass a command along with link button and apply logic in row command event

Madhu Nair 28-Oct-13 2:57am

post this as Answer!!!

4 solutions

Solution 1

I added a code in LinkButton

ASP.NET

<asp:linkbutton runat="server" id="lbtn" text="Pay" commandargument="<%# Eval("amount") %>" commandname="Select" xmlns:asp="#unknown"></asp:linkbutton>

  <asp:label id="lblMessage" runat="server" xmlns:asp="#unknown"></asp:label>   
    
  <asp:textbox id="txtMobile" runat="server" xmlns:asp="#unknown"></asp:textbox>

Added In my code Behind

C#

protected void gv_rowcommand(object sender, GridViewCommandEventArgs e)
   {
       if (e.CommandName == "Select")
       {
           txtMobile.Text = Convert.ToString(e.CommandArgument);
           lblMessage.Text = "Amount = ";

       }
   }

It will display the Selected Row Amount.....

Now i want to Display Entire Row Information like that......

Posted 27-Oct-13 21:34pm

Venkat Kumar chigulla

Solution 3

One way i have for this
at the time page load when first time data diplayed
onRowdatabound event of grid you can add attribute postback url to link button
by appending all column values in query string now when you will click on link it redirect you to that page on that you can fetch all values from this string.

Hope this helps!!!

Posted 27-Oct-13 22:33pm

C For Code!!!

Solution 4

Assign the gridview values to variables like this in rowcommand eventhandler-

C#

string co = grow.Cells[1].Text;
string date = grow.Cells[2].Text;

You can use sessions,query string etc -

C#

//and then concatenate these string variable and add with the targeted aspx page like-
Response.Redirect("Default2.aspx?course=" + co+ "&date=" + date);

simillarly if you want to add more values just add '&' and concatenate..

On default2.aspx

use textbox or label(whatever you want)to display the information like..

C#

coursetxt.text=Request.QueryString["course"]

hope this helps!

Posted 27-Oct-13 23:25pm

Rawat.Manoj

Comments

Venkat Kumar chigulla 28-Oct-13 7:37am

If we use Querystring the information will show in the URL, is there any alternative for this..?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rawat.Manoj · Accepted Answer · 2013-10-27T22:06:00

What shabarinadh.vempati is trying to say is -

Add 'OnRowCommand' event to your gridview like-

C#

<asp:gridview id="gvap" runat="server" autogeneratecolumns="false" onrowcommand="gvap_RowCommand" xmlns:asp="#unknown"></asp:gridview>

and add commandname property to your linkbutton

and then on its eventhandler in code behind file do something like -

C#

protected void gvap_RowCommand(objectsender,GridViewCommandEventArgs e)
    {
        if (e.CommandName == "EditMe")
        {
            GridViewRow grow = (GridViewRow)(((linkbutton)e.CommandSource).NamingContainer);
            hdn.Value = grow.Cells[1].Text;


        }

do something like this try to access the grid's row values using any state management technique..

One more thing write the whole sql interation and databinding in a function and call it on page load with a (!ispostback)like -

C#

public void populategrid()
{
SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Data Source=(local); Initial Catalog=123; User Id=sa; Password=123; Integrated Security=false";
 

        //Assigning Query
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = conn;
        cmd.CommandText = "select course_name , start_date , end_date, timings, amount from courses where start_date>=GETDATE()";
        cmd.CommandType = CommandType.Text;
        
 
        //Execute the COmmand
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.SelectCommand = cmd;
        DataSet ds = new DataSet();
        da.Fill(ds);
        gvap.DataSource = ds;
        gvap.DataBind(); 
}

and then on page load

C#

if(!ispostback)
{
populategrid();
}