In this blog we will know how to display selected row value of a grid view in dropdown list.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Select_row_value_gridview_dropdown._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 Page</title>
</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"
onselectedindexchanged="GridView1_SelectedIndexChanged">
<AlternatingRowStyle BackColor="#FFCC66" />
</asp:GridView>
<br />
<asp:Label ID="lb1" runat="server" Text="ID : " Font-Bold="True" Width="100px"></asp:Label>
<asp:DropDownList ID="ddl_id" runat="server">
</asp:DropDownList>
<br />
<br />
<asp:Label ID="lb3" runat="server" Text="NAME : " Font-Bold="True"
Width="100px"></asp:Label>
<asp:DropDownList ID="ddl_name" runat="server">
</asp:DropDownList>
<br />
<br />
<asp:Label ID="lb5" runat="server" Text="ADDRESS : " Font-Bold="True"
Width="100px"></asp:Label>
<asp:DropDownList ID="ddl_address" runat="server">
</asp:DropDownList>
<br />
<br />
<asp:Label ID="lb7" runat="server" Text="MARK : " Font-Bold="True"
Width="100px"></asp:Label>
<asp:DropDownList ID="ddl_marks" runat="server">
</asp:DropDownList>
<br />
<br />
<asp:Label ID="lb9" runat="server" Text="YEAR : " Font-Bold="True"
Width="100px"></asp:Label>
<asp:DropDownList ID="ddl_year" runat="server">
</asp:DropDownList>
</div>
</form>
</body>
</html>
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 Select_row_value_gridview_dropdown
{
public partial class _Default : System.Web.UI.Page
{
string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
string str;
SqlCommand com;
SqlDataAdapter sqlda;
DataSet ds;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bindgrid();
}
}
void bindgrid()
{
SqlConnection con = new SqlConnection(strConnString);
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();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
ddl_id.Items.Clear();
ddl_name.Items.Clear();
ddl_address.Items.Clear();
ddl_marks.Items.Clear();
ddl_year.Items.Clear();
ddl_id.Items.Add(GridView1.SelectedRow.Cells[1].Text);
ddl_name.Items.Add(GridView1.SelectedRow.Cells[2].Text);
ddl_address.Items.Add(GridView1.SelectedRow.Cells[3].Text);
ddl_marks.Items.Add(GridView1.SelectedRow.Cells[4].Text);
ddl_year.Items.Add(GridView1.SelectedRow.Cells[5].Text);
}
}
}