how to coding in gridlinkbutton

Question

hello sir. i have coding in on linkbutton of gridview like ex.pertucular record check in other table... plz give me some example....

Rajneesh Rai · Answer

Hello Geek, suppose you grid show student data (roll, name) on.aspx page ------------------------------------------------------------------------- OnRowCommand="Grid_RowCommand" > ' CommandName="Roll" CommandArgument=' '> ----------------------------------------------------------------------------- Code behind file ------------------------------------------------------------------------------ public partial class GridView : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { List students = new List { new Student(){roll = 1,name = "Amit"}, new Student(){roll =2, name ="Rajneesh"} }; GridView1.DataSource = students; GridView1.DataBind(); } protected void Grid_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Roll") { //e.CommandArgument // now get your roll no and search it into your db // or whatever you want to do } } public class Student { public int roll { get; set; } public string name { get; set; } } } --------------------------------------------------------------------------------- when you click on link button (roll no) OnRowCommand event would be fired and the control goes in Grid_RowCommand , from there you can get details of particular link who raised it. and get value from CommandArgument, and from here you can accomplish any task that you want to perform, like fetching data from another table using this data... hope this is clear to you

Satyapriya Nayak · Answer

Untitled Page using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Display_related_records_gridview { public partial class test3 : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlCommand com; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { bindgrid(); } } private void bindgrid() { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select * from employee"; com = new SqlCommand(str, con); SqlDataReader reader; reader = com.ExecuteReader(); g1.DataSource = reader; g1.DataBind(); con.Close(); } } } Untitled Page Empname:   Empaddress:   Empsal:   Empphone:   Empfax:   Empcity:   Empstate:   Empzip:   Emplic:   Empstatus:   using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Display_related_records_gridview { public partial class test4 : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; string s1; SqlCommand com; protected void Page_Load(object sender, EventArgs e) { try { SqlConnection con = new SqlConnection(strConnString); con.Open(); s1 = Request.QueryString[0]; str = "select * from employee where empid='" + s1 + "'"; com = new SqlCommand(str, con); SqlDataReader reader; reader = com.ExecuteReader(); if (reader.Read()) { Label1.Text = reader["empname"].ToString(); Label2.Text = reader["empaddress"].ToString(); Label3.Text = reader["empsal"].ToString(); Label4.Text = reader["empphone"].ToString(); Label5.Text = reader["empfax"].ToString(); Label6.Text = reader["empcity"].ToString(); Label7.Text = reader["empstate"].ToString(); Label8.Text = reader["empzip"].ToString(); Label9.Text = reader["emplic"].ToString(); Label10.Text = reader["empstatus"].ToString(); } } catch (Exception ex) { Response.Write(ex.Message); } } } }