Bind Dropdownlist in Gridview Rowdatabound
Display Some Details in Gridview but we need list of values show to the user on gridview we bind the inside of gridview Dropdownlist using RoeDataBound event method Asp.Net C#.
DEMO
Download
HTML CODING
C# CODING
Display Some Details in Gridview but we need list of values show to the user on gridview we bind the inside of gridview Dropdownlist using RoeDataBound event method Asp.Net C#.
DEMO
Download
HTML CODING
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Gridview.aspx.cs" Inherits="Mysql_StoredProcedure" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div align="center">
<table>
<tr><td> </td><td>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowDataBound="GridView1_RowDataBound" OnRowEditing="GridView1_RowEditing">
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:TemplateField HeaderText="User Id">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("UserId") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="User Name">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<HeaderStyle ForeColor="#CC3300" />
</asp:GridView>
</td></tr>
</table>
</div>
</form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;
using System.Data;
public partial class Mysql_StoredProcedure : System.Web.UI.Page
{
protected void GridBind()
{
MySqlConnection con = new MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["dbc"].ToString());
con.Open();
MySqlCommand cmd = new MySqlCommand("select * from userinformation", con);
MySqlDataAdapter adp = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
}
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
GridBind();
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
// GridViewRow gr = (GridViewRow)FindControl("GridView1");
DropDownList ddl = (DropDownList)e.Row.FindControl("DropDownList1");
MySqlConnection con = new MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["dbc"].ToString());
con.Open();
MySqlCommand cmd1 = new MySqlCommand("select UserName from userinformation", con);
MySqlDataReader rd1 = cmd1.ExecuteReader();
ddl.Items.Clear();
ddl.Items.Add("Select Username");
while (rd1.Read())
{
ddl.Items.Add(rd1[0].ToString());
}
con.Close();
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
// GridViewRow gr = (GridViewRow)FindControl("GridView1");
DropDownList ddll = (DropDownList)e.Row.FindControl("DropDownList1");
MySqlConnection con1 = new MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["dbc"].ToString());
con1.Open();
MySqlCommand cmd = new MySqlCommand("select UserName from userinformation", con1);
MySqlDataReader rd = cmd.ExecuteReader();
ddl.Items.Clear();
ddl.Items.Add("Select Username");
while (rd.Read())
{
ddll.Items.Add(rd[0].ToString());
}
con1.Close();
}
}
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
GridBind();
}
}
0 comments:
Post a Comment