siamandm says:
protected void btnSelect_Click(object sender, EventArgs e)
{
Int64 GVAssetList_ID = Convert.ToInt64(GVAssetList.SelectedRow.Cells[0].Text);
Session["GVAssetList_ID"] = GVAssetList_ID;
ddlMake.DataBind();
GridViewRow SelectedRow = ((sender as Button).NamingContainer as GridViewRow);
pnlEditAsset.Visible = true;
lblAssetID.Text = SelectedRow.Cells[0].Text;
txtAssetName.Text = SelectedRow.Cells[1].Text;
txtAssetSN.Text = SelectedRow.Cells[2].Text;
ddlMake.ClearSelection();
ddlMake.Items.FindByText(SelectedRow.Cells[3].Text.Trim()).Selected = true;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Session["GVAssetList_ID"] = GVAssetList.SelectedDataKey.Value;
try
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SP_EditAsset";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Asset_ID", Convert.ToInt32(Session["GVAssetList_ID"]));
cmd.Parameters.AddWithValue("@Asset_Name", txtAssetName.Text);
cmd.Parameters.AddWithValue("@Asset_SN", txtAssetSN.Text);
cmd.Parameters.AddWithValue("@Asset_Make", ddlMake.SelectedValue);
cmd.Parameters.AddWithValue("@Asset_Model", ddlModel.SelectedValue);
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
con.Close();
lblmsg.Text = "Asset Update!!";
GVAssetList.DataBind();
}
catch
{
}
}
Change the two events with the below code.
protected void btnSelect_Click(object sender, EventArgs e)
{
ddlMake.DataBind();
GridViewRow SelectedRow = ((sender as Button).NamingContainer as GridViewRow);
Session["GVAssetList_ID"] = GVAssetList.DataKeys[SelectedRow.RowIndex].Value;
pnlEditAsset.Visible = true;
txtAssetName.Text = SelectedRow.Cells[1].Text;
txtAssetSN.Text = SelectedRow.Cells[2].Text;
ddlMake.ClearSelection();
ddlMake.Items.FindByText(SelectedRow.Cells[2].Text.Trim()).Selected = true;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (Session["GVAssetList_ID"] != null)
{
try
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SP_EditAsset";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Asset_ID", Convert.ToInt32(Session["GVAssetList_ID"]));
cmd.Parameters.AddWithValue("@Asset_Name", txtAssetName.Text);
cmd.Parameters.AddWithValue("@Asset_SN", txtAssetSN.Text);
cmd.Parameters.AddWithValue("@Asset_Make", ddlMake.SelectedValue);
cmd.Parameters.AddWithValue("@Asset_Model", ddlModel.SelectedValue);
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
con.Close();
lblmsg.Text = "Asset Update!!";
GVAssetList.DataBind();
}
catch
{
}
}
}