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
{
}
}
}