How can i am Add sqlData Base values in gridview dropdown list ....

Sachin Mitna

if (!IsPostBack)

{

SetIntailRow();

// SetGrid();

this.BindGrid();

}

SqlConnection con = new SqlConnection(@"Data Source=AQSASHAIKH\SQLEXPRESS;Initial Catalog=Client;Integrated Security=True");

string com = "Select * From [dbo].[client]";

SqlDataAdapter da = new SqlDataAdapter(com, con);

DataTable dt = new DataTable();

da.Fill(dt);

DropDownList1.DataSource = dt;

DropDownList1.DataBind();

DropDownList1.DataTextField = "Name";

DropDownList1.DataValueField = "id";

DropDownList1.DataBind();

SqlConnection Conn = new SqlConnection(@"Data Source=AQSASHAIKH\SQLEXPRESS;Initial Catalog=Client;Integrated Security=True");

SqlCommand Comm1 = new SqlCommand(com, Conn);

Comm1.Connection = Conn;

Comm1.CommandText = "SELECT COUNT(*) FROM client";

Conn.Open();

TxtBox1.Text = Comm1.ExecuteScalar().ToString();

TxtBox2.Text = Comm1.ExecuteScalar().ToString();

Conn.Close();

}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Hi,

You need to bind your dropdown inside OnRowDataBound event, Please refer this link,
https://www.aspsnippets.com/Articles/How-to-populate-DropDownList-in-GridView-in-ASPNet.aspx
Sachin Singh6y ago
If your DropdownList is inside Gridview and you want to populate it while binding the Gridview then You will have to use OnRowDataBound event of Gridview which behind the scene binds each row of your Gridview.
protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        //Find the DropDownList in the Row
        DropDownList ddlCountries = (e.Row.FindControl("ddlCities") as DropDownList);
        ddlCities.DataSource = yourDataSource;// your data source
        ddlCities.DataTextField = "Name";
        ddlCities.DataValueField = "Id";
        ddlCities.DataBind();

        //Add Default Item in the DropDownList
        ddlCities.Items.Insert(0, new ListItem("Please select"));

        ddlCities.Items.FindByValue(Name).Selected = true;
    }
}
Only the ItemTemplate fields need to be populated explicitely , your BoundField will be auto populate as soon as you assign a DataSource to Gridview and call its DataBind() method.
Mageshwaran R6y ago
Hi Sachin,
Please try this code:
SqlConnection oconnect = new SqlConnection(@"Data Source=AQSASHAIKH\SQLEXPRESS;Initial Catalog=Client;Integrated Security=True");
           SqlCommand ocmnd = new SqlCommand("SELECT *FROM client", oconnect.openconnection());
           ocmnd.ExecuteNonQuery();
           SqlDataAdapter odapt = new SqlDataAdapter(ocmnd);
           DataTable odt = new DataTable();
           odapt.Fill(odt);
           grdname.DataSource = odt.AsDataView();
           grdname.DataBind();
Rajanikant Hawaldar6y ago
Hello Sachin, Refer below article explianed very well with code and you can also download code files.

https://www.c-sharpcorner.com/UploadFile/009464/use-dropdownlist-in-gridview-in-Asp-Net-using-C-Sharp/