How to get value from gridview?

Question

2.50/5 (2 votes)

See more:

InteractionName	Drug Name	Drug Type	Menufacturer Name	Drug Description
fff	        hhh	        Teblet	        cadila	                mmm
fff	        lll	        Teblet	        cadila	                mmm
fff	        hhh	        Injection	cadila	                ppp

----------------------------------------------------------------
above is my grid and i want to pass value of interaction name,DrugId,and DrugName column when i click on interaction name using query string..

-----------------------------

C#

 protected void gvDrug_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "cmdView")
            {
                Response.Redirect("AddNewDrug.aspx?DrugId=" + e.CommandArgument.ToString());
            }
            if (e.CommandName == "cmdInteractionName")
            {
                
                Response.Redirect("DrugInteraction.aspx?InteractionId="+e.CommandArgument.ToString()+"DrugId=");
                
            }
}

Posted 18-Mar-14 19:19pm

Member 10671989

Updated 18-Mar-14 19:40pm

VICK

v2

Add a Solution

Comments

BulletVictim 19-Mar-14 1:25am

dgvDrug.Rows(e.CommandArgument).Cells(n).Text

VICK 19-Mar-14 1:39am

Do Paste Your gridview's HTML to show how you are binding for the command arguments.

Member 10671989 19-Mar-14 2:51am

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPages/MyPortalMaster.Master" AutoEventWireup="true" CodeBehind="DrugList.aspx.cs" Inherits="PortalErx.Administration.DrugList" %>
<%@ MasterType VirtualPath="~/MasterPages/MyPortalMaster.Master" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<table width="100%">
<tr>
<td align="center">
<asp:Label ID="lblMessage" runat="server" ForeColor="Red">
</td>
</tr>
<tr>

<td align="right">

<asp:Button ID="btnNew" runat="server"
Text="Add New Drug" CssClass="btn" onclick="btnNew_Click" />

</td>

</tr>

<tr>
<td>
<asp:GridView ID="gvDrug" runat="server" AutoGenerateColumns="False"
Width="100%" CssClass="mGrid" onrowcommand="gvDrug_RowCommand"
>
<columns>
<asp:TemplateField HeaderText="InteractionName"
SortExpression="InteractionName">
<itemtemplate>
<asp:LinkButton ID="lbInteractionName" runat="server"
CommandArgument='<%# Eval("InteractionId") %>' CommandName="cmdInteractionName"
Text='<%# Eval("InteractionName") %>'>

<asp:TemplateField HeaderText="Drug Name">
<itemtemplate>
<asp:LinkButton ID="lbtnName" CommandName="cmdView" CommandArgument='<%# Eval("DrugId") %>'
runat="server" ToolTip="View/Edit Drug Details" Text='<%# Eval("DrugName") %>'>

<asp:BoundField DataField="DrugType" HeaderText="Drug Type" />
<asp:BoundField DataField="MenufacturerName" HeaderText="Menufacturer Name" />
<asp:BoundField DataField="DrugDescription" HeaderText="Drug Description" />

</td>

</tr>

</table>

Member 10671989 19-Mar-14 3:43am

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPages/MyPortalMaster.Master" AutoEventWireup="true" CodeBehind="DrugList.aspx.cs" Inherits="PortalErx.Administration.DrugList" %>
<%@ MasterType VirtualPath="~/MasterPages/MyPortalMaster.Master" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<table width="100%">
<tr>
<td align="center">
<asp:Label ID="lblMessage" runat="server" ForeColor="Red">
</td>
</tr>
<tr>

<td align="right">

<asp:Button ID="btnNew" runat="server"
Text="Add New Drug" CssClass="btn" onclick="btnNew_Click" />

</td>

</tr>

<tr>
<td>
<asp:GridView ID="gvDrug" runat="server" AutoGenerateColumns="False"
Width="100%" CssClass="mGrid" onrowcommand="gvDrug_RowCommand" onselectedindexchanged="gvDrug_SelectedIndexChanged"
>
<columns>
<asp:TemplateField HeaderText="InteractionName"
SortExpression="InteractionName">
<itemtemplate>
<asp:LinkButton ID="lbtInteractionName" runat="server"
CommandArgument='<%# Eval("InteractionId") %>' CommandName="cmdInteractionName"
Text='<%# Eval("InteractionName") %>'>

<asp:TemplateField HeaderText="Drug Name">
<itemtemplate>
<asp:LinkButton ID="lbtDrugName" CommandName="cmdView" CommandArgument='<%# Eval("DrugId") %>'
runat="server" ToolTip="View/Edit Drug Details" Text='<%# Eval("DrugName") %>'>

<asp:BoundField DataField="DrugType" HeaderText="Drug Type" />
<asp:BoundField DataField="MenufacturerName" HeaderText="Menufacturer Name" />
<asp:BoundField DataField="DrugDescription" HeaderText="Drug Description" />

</td>

</tr>

</table>

2 solutions

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)

Peter Leow · Answer 1 · 2014-03-18T19:45:00

Solution 1

Suggest adding another column say Select for user to select a row, that makes your intention clearer and helps improve the usability. Refer: How-to-get-Selected-Row-cell-value-from-GridView-in-ASPNet.aspx[^]

Posted 18-Mar-14 19:45pm

Peter Leow

Updated 18-Mar-14 19:48pm

v2

Comments

VICK 20-Mar-14 1:42am

My5+.

Peter Leow 20-Mar-14 1:56am

Thanks Vick.

**VICK** · Answer 2 · 2014-03-18T22:47:00

Change your link button like below to pass multiple values as command argument.
As you want to pass InteractionName, DrugID and DrugColumn, HTML can be like below,

C#

<asp:linkbutton id="lbtInteractionName" runat="server" xmlns:asp="#unknown">
      CommandArgument='<%# Eval("InteractionId") %>, <%# Eval("DrugId") %>,<%# Eval("DrugName") %>'
      CommandName="cmdInteractionName" 
      Text='<%# Eval("InteractionName") %>'></asp:linkbutton>

AND in RowCommandEvent of Gridview, You can get all of the command arguments by splitting based on comma(,). like below.

C#

String[] values = e.CommandArgument.ToString().Split(',');

hope it will help. :)