// Handler grvwObj_RowDataBound handling GridView RowDataBound Event
protected void grvwObj_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow && e.Row.RowState != DataControlRowState.Edit)
{
int countryid;
Label lblCountry = (Label)e.Row.FindControl("lblCountry");
if (lblCountry != null)
{
countryid = Convert.ToInt32(lblCountry.Text);
ViewState["countryid"] = lblCountry.Text;
objCountry = objCountry.Get_By_id(countryid);
lblCountry.Text = objCountry.Countryname.ToString();
}
}
if (e.Row.RowState == DataControlRowState.Edit)
{
DropDownList dropCountry = (DropDownList)e.Row.FindControl("dropCountry");
BLLCollection <Country_mst> col = new BLLCollection <Country_mst>();
col = objCountry.Get_All();
dropCountry.DataSource = col;
dropCountry.DataTextField = "countryname";
dropCountry.DataValueField = "countryid";
dropCountry.DataBind();
dropCountry.SelectedValue = ViewState["countryid"].ToString();
}
if (e.Row.RowState == (System.Web.UI.WebControls.DataControlRowState.Alternate | System.Web.UI.WebControls.DataControlRowState.Edit))
{
DropDownList dropCountry = (DropDownList)e.Row.FindControl("dropCountry");
BLLCollection <Country_mst> col = new BLLCollection <Country_mst>();
col = objCountry.Get_All();
dropCountry.DataSource = col;
dropCountry.DataTextField = "countryname";
dropCountry.DataValueField = "countryid";
dropCountry.DataBind();
dropCountry.SelectedValue = ViewState["countryid"].ToString();
}
}
// Handler grvwObj_RowDataBound handling GridView RowDataBound Event
protected void grvwObj_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow && e.Row.RowState != DataControlRowState.Edit)
{
int countryid;
Label lblCountry = (Label)e.Row.FindControl("lblCountry");
if (lblCountry!=null)
{
countryid = Convert.ToInt16(lblCountry.Text);
ViewState["countryid"] = lblCountry.Text;
objCountry = objCountry.Get_By_id(countryid);
lblCountry.Text = objCountry.Countryname.ToString();
}
}
if (e.Row.RowState == DataControlRowState.Edit )
{
DropDownList dropCountry = (DropDownList)e.Row.FindControl("dropCountry");
BLLCollection<Country_mst> col = new BLLCollection<Country_mst>();
col = objCountry.Get_All();
dropCountry.DataSource = col;
dropCountry.DataTextField = "countryname";
dropCountry.DataValueField = "countryid";
dropCountry.DataBind();
dropCountry.SelectedValue = ViewState["countryid"].ToString();
}
if (e.Row.RowState == (System.Web.UI.WebControls.DataControlRowState.Alternate | System.Web.UI.WebControls.DataControlRowState.Edit))
{
DropDownList dropCountry = (DropDownList)e.Row.FindControl("dropCountry");
BLLCollection<Country_mst> col = new BLLCollection<Country_mst>();
col = objCountry.Get_All();
dropCountry.DataSource = col;
dropCountry.DataTextField = "countryname";
dropCountry.DataValueField = "countryid";
dropCountry.DataBind();
dropCountry.SelectedValue = ViewState["countryid"].ToString();
}
}
public int Update_Country_mst_By_id(Country_mst objCountry)
{
return (int)ExecuteNonQuery(Sp_Country_Update, new object[] { objCountry.Countryname, objCountry.Countryid });
}
public int Insert_Country_mst(Country_mst objCountry)
{
return (int)ExecuteNonQuery(Sp_Country_Insert, new object[] { objCountry.Countryname, objCountry.Countryid });
}
public object GenerateCountry_mstObject(ref IDataReader returnData)
{
Country_mst obj = new Country_mst();
while (returnData.Read())
{
obj.Countryid = (int)returnData["Countryid"];
obj.Countryname = (string)returnData["Countryname"];
}
returnData.Close();
returnData.Dispose();
return obj;
}
public CollectionBase GenerateCountry_mstCollection(ref IDataReader returnData)
{
BLLCollection<Country_mst> col = new BLLCollection<Country_mst>();
while (returnData.Read())
{
Country_mst obj = new Country_mst();
obj.Countryid = (int)returnData["Countryid"];
obj.Countryname = (string)returnData["Countryname"];
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
