System.Data.Datarawview

Sahil Jani

15y2.7k.NET

Hi,

I am populating dropdown into gridview.when i am running application, in dropdown it shows me this data System.Data.Datarawview.

Here I have pasted my code :

public void FindControlInGV()

{

foreach (GridViewRow gvr in gvPopulate.Rows)

{

SqlDataAdapter ad = new SqlDataAdapter("select B_Element from Test_Table", con);

DataSet ds = new DataSet();

ad.Fill(ds, "Test_Table");

DropDownList ddlSelect = new DropDownList();

ddlSelect = (DropDownList)gvr.Cells[0].FindControl("ddlPopulate");

ddlSelect.DataSource = ds;

ddlSelect.DataBind();

}

//}

}

I am new to asp.net pls help me out.

4 Replies

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

Suthish Nair15y ago
Accepted answer
You are missing ..

ddlSelect.DataSource = ds.Tables(0)
ddlSelect.DataTextField = "Column name to de displayed to user"
ddlSelect.DataValueField = "Column name for your logic"
ddlSelect.DataBind()
Sahil Jani15y ago
Thnks suthis. I have done it.
Jiteendra Sampathirao15y ago
Hi, follow this procedure...........

public void FillDropDownList()
{
s = WebConfigurationManager.ConnectionStrings["ChartDatabaseConnectionString"].ConnectionString;
con = new SqlConnection(s);
con.Open();
cmd = new SqlCommand("Select StudentName from Student", con);
dr = cmd.ExecuteReader();
while (dr.Read())
{
DropDownList1.Items.Add(dr[0].ToString());
}
dr.Close();
con.Close();
}

otherwise...

i think mistake is locates here

ddlSelect = (DropDownList)gvr.Cells[0].FindControl("ddlPopulate");
Sandeep Shekhawat15y ago
protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DropDownList d;
d = (DropDownList)e.Row.FindControl("DropDownList1");

adp = new SqlDataAdapter("select * from tbl_contact", cn);
adp.Fill(ds);
d.DataSource = ds;
d.DataTextField = "name";
d.DataBind();
}
}
use this this symptoms comes for dropdown list that have no value and text filed.