navigate linkbutton and count row from gridveiw control?

Question

0.00/5 (No votes)

See more:

Dear All,

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class Jobs_Accounting : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            try
            {
                Userid.Value = Session["ID"].ToString();
            }
            catch
            {
            }
        }
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        int s1 = GridView1.SelectedIndex;

        string ss = GridView1.Rows[s1].Cells[1].Text;

        SqlConnection a = new SqlConnection(ConfigurationManager.ConnectionStrings["abcConnectionString"].ConnectionString);
        a.Open();

        string cartCmd = "insert into savetable(userid,productid,Quantity) values('" + Userid.Value + "','" + ss + "','" + 1 + "') ";

        SqlCommand cmd = new SqlCommand(cartCmd, a);
        cmd.ExecuteNonQuery();
        a.Close();
    }
}

in the above code once select button control go to the gridviewrow----------line

but not go to the selected changed event why please reply me

Posted 24-Feb-14 0:27am

member1431

Updated 24-Feb-14 1:07am

Tom Marvolo Riddle

v2

Add a Solution

Comments

Tom Marvolo Riddle 24-Feb-14 6:51am

try it:
http://www.aspdotnet-suresh.com/2010/04/detect-browser-refresh-to-avoid-events.html[^]

member1431 24-Feb-14 7:18am

error:

Unable to cast object of type 'System.Web.UI.WebControls.GridView' to type 'System.Web.UI.WebControls.LinkButton'.

{
Line 47:
Line 48: GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).NamingContainer;
Line 49: int rowIndex = row.RowIndex;

this is error

1 solution

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)

Tom Marvolo Riddle · Answer 1 · 2014-02-24T01:06:00

Solution 1

Try like this:

C#

protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
      Session["CheckRefresh"]= Server.UrlDecode(System.DateTime.Now.ToString());
     }
 }

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
  if (Session["CheckRefresh"].ToString()==ViewState["CheckRefresh"].ToString())
     {
         int s1 = GridView1.SelectedIndex;

         string ss = GridView1.Rows[s1].Cells[1].Text;

    SqlConnection a = new SqlConnection(ConfigurationManager.ConnectionStrings["abcConnectionString"].ConnectionString);
         a.Open();

         string cartCmd = "insert into savetable(userid,productid,Quantity) values('" + Userid.Value + "','" + ss + "','" + 1 + "') ";

         SqlCommand cmd = new SqlCommand(cartCmd, a);
         cmd.ExecuteNonQuery();
         a.Close();
  Session["CheckRefresh"] = Server.UrlDecode(System.DateTime.Now.ToString());
     }
 }

Posted 24-Feb-14 1:06am

Tom Marvolo Riddle

Comments

member1431 24-Feb-14 7:15am

Dear Jas,

I got same error once click the button that control goes to gridview row----------line

ok jas leave it i will try later
thanks for your reply jas

Tom Marvolo Riddle 24-Feb-14 7:17am

what error you are getting? try it and let me know.It should work

Tom Marvolo Riddle 24-Feb-14 7:29am

post your html markup

member1431 24-Feb-14 7:32am

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"
Culture="en-IN" CodeFile="MobilePhones-ComputersSoftware.aspx.cs" Inherits="Styles_MobilePhones_ComputersSoftware" %>

<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="Server">
<div>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" Width="100%" AutoGenerateColumns="False"
DataKeyNames="Id" DataSourceID="SqlDataSource1" HeaderStyle-HorizontalAlign="Justify"
GridLines="Horizontal" OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
OnRowCommand="GridView1_RowCommand" onprerender="GridView1_PreRender">
<columns>
<asp:CommandField ShowSelectButton="True" Visible="False" ButtonType="Button" />
<asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True"
SortExpression="Id" />
<asp:TemplateField HeaderText="Image" SortExpression="Image">
<edititemtemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Image") %>'>

<itemtemplate>
<asp:Image ID="Image1" runat="server" Width="100px" Height="100px" ImageUrl='<%# Bind("Image") %>'>

<asp:TemplateField HeaderText="Title" SortExpression="Title">
<edititemtemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Title") %>'>

<itemtemplate>
<asp:LinkButton ID="LinkButton2" runat="server" Text='<%# Bind("Title") %>'>

<asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
<asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" DataFormatString="{0:C}" />
<asp:BoundField DataField="Location" HeaderText="Location" SortExpression="Location" />
<asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
<asp:BoundField DataField="Mobile" HeaderText="Mobile" SortExpression="Mobile" />
<asp:BoundField DataField="ContactName" HeaderText="ContactName" SortExpression="ContactName" />
<asp:BoundField DataField="DateAdded" HeaderText="DateAdded" SortExpression="DateAdded" />
<asp:CommandField ShowSelectButton="True" SelectText="Save" ButtonType="Button" />

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:abcConnectionString %>"
SelectCommand="SELECT [Id], [Image], [Title], [Description], [Price], [Location], [Email], [Mobile], [ContactName], [DateAdded] FROM [ProductDetails] where CategoriesType='Computer & Software'">

<asp:Label ID="Label1" runat="server" Text="Label">
</div>
<asp:HiddenField ID="Userid" runat="server" />

Tom Marvolo Riddle 24-Feb-14 7:37am

IN .cs page where is the rowcommand event

member1431 24-Feb-14 7:38am

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{

GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).NamingContainer;
int rowIndex = row.RowIndex;

if (rowIndex == 0)
{
Response.Redirect("Computer.aspx");
}

}

Tom Marvolo Riddle 24-Feb-14 7:40am

Try it in gridview
<asp:LinkButton ID="LinkButton1" runat="server" CommandName ="Select">
LinkButton</Linkbutton>

Tom Marvolo Riddle 24-Feb-14 8:12am

I didn't get the code clearly.Use Improve[^] to edit the question and update it with proper code

Tom Marvolo Riddle 24-Feb-14 7:38am

i tried at my end it's working fine