ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview,SQL Server,Ajax,SSRS,AngularJs,C#,Gridview Row,dotnet XML examples

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

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Gridview.aspx.cs" Inherits="Mysql_StoredProcedure" %>

<!DOCTYPE html>

</head>

<body>

<table>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowDataBound="GridView1_RowDataBound" OnRowEditing="GridView1_RowEditing">

<asp:CommandField ShowEditButton="True" />

<asp:TemplateField HeaderText="User Id">

<asp:Label ID="Label1" runat="server" Text='<%# Eval("UserId") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="User Name">

<asp:DropDownList ID="DropDownList1" runat="server">

</asp:DropDownList>

</EditItemTemplate>

<asp:DropDownList ID="DropDownList1" runat="server">

</asp:DropDownList>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</td></tr>

</table>

</div>

</form>

</body>

</html>

C# CODING

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();

}

Add New web form - add Gridview - Edit Column - add - two Template fields

Bind the User id - Gridview - Edit Template field

Add - Dropdownlist to Gridview Item Template field

Next - shown below like gridview - add gridview event - Rowdatabound

Below code for Gridview Itemtemplate Bind Coding

Next - Add Gridview - Commandfield - Edit Field

Next - Add EditItemTemplate - Bind the Dropdownlist

Next - Shown below like Gridview - Gridview event - add RowEditing

Below code for Gridview Edit template Bind Coding

Add a Confirm delete option in ASP.Net

Display multiple details in Gridview we want to delete some row before confirmation messahe open confirm delete that is onclientclick event Using Asp.Net C#.

DEMO