Comments by mibi@4289 (Top 12 by date)

i am getting an exception as Object reference not set to an instance of an object. Please help me
protected void grv1_RowDataBound(object sender, GridViewRowEventArgs e)
{

if (grv1 .EditIndex == e.Row.RowIndex)
{
SqlConnection oconn = new SqlConnection(conn);
oconn.Open();
SqlDataAdapter oda = new SqlDataAdapter ("select*from Designation", oconn);
DropDownList ddl = (DropDownList)e.Row.Cells[2].FindControl("ddldesignation");
DataSet ds = new DataSet();
oda.Fill(ds,"temp");
ddl.DataSource = ds.Tables[0].DefaultView ;
ddl.DataTextField = "DESIGNAME";
ddl.DataValueField = "DESIGID";
ddl.DataBind();
//databind here
}

Thank you,i got the join query, but i need the coding for binding dropdownlist while editing

i want the coding for the above mentioned exercise. please help me out

string conn = ConfigurationManager.ConnectionStrings["connect"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FillGrid();
}

}

protected void grv1_RowEditing(object sender, GridViewEditEventArgs e)
{
grv1.EditIndex = e.NewEditIndex;
FillGrid();


void FillGrid()
{
SqlConnection oconn = new SqlConnection(conn);
oconn.Open();
SqlDataAdapter oda = new SqlDataAdapter("select E.EID,E.ENAME,D.DESIGNAME from Employee E Inner join Designation D on D.DesigID =E.DesigID", oconn);
DataSet ds = new DataSet ();
oda.Fill(ds,"temp");
grv1.DataSource = ds.Tables[0];
grv1.DataBind();
oconn.Close();
}


protected void grv1_RowDataBound(object sender, GridViewRowEventArgs e)
{

SqlDataReader ddr = null;
SqlConnection oconn = new SqlConnection(conn);

SqlCommand ocmd = new SqlCommand("select*from designation", oconn);
oconn.Open();
ddr = ocmd.ExecuteReader(CommandBehavior.CloseConnection);
DropDownList ddl = new DropDownList();
if (grv1.EditIndex == e.Row.RowIndex)
{
ddl = (DropDownList)e.Row.Cells[2].FindControl("ddldesignation");
ddl.DataSource = ddr;
ddl.DataTextField = "DesigName";
ddl.DataValueField = "DesigId";
ddl.DataBind();
}

i got this exercise in my interview. i couldn't do it using dropdownlist.
i am trying it but not getting.. Please help in this.

i couldn't bind the dropdownlist on click of Edit link. Please help me out..