james henderson
asked on
gridview control not updating
I am having trouble updating the database from the gridview edit row. I am building the list of parameters to send to a stored proc, calling the stored proc, and then re-loading the gridview. However, at the point where I am populating the values for the parameters, I am getting the original values, not the new values I have already typed into the text boxes.
here are the two events in play:
protected void gvCallList_RowEditing(obje ct sender, GridViewEditEventArgs e)
{
gvCallList.EditIndex = e.NewEditIndex;
BindCallList();
}
protected void gvCallList_RowUpdating(obj ect sender, GridViewUpdateEventArgs e)
{
int idx = gvCallList.EditIndex;
GridViewRow row = gvCallList.Rows[idx];
string RowId = gvCallList.DataKeys[idx].V alue.ToStr ing();
string PharmacyName = ((TextBox)row.FindControl( "txtPharma cyName")). Text;
string Address1 = ((TextBox)row.FindControl( "txtAddres s1")).Text ;
string Address2 = ((TextBox)row.FindControl( "txtAddres s2")).Text ;
string City = ((TextBox)row.FindControl( "txtCity") ).Text;
string State = ((TextBox)row.FindControl( "txtState" )).Text;
string Zip = ((TextBox)row.FindControl( "txtZip")) .Text;
string PhoneNo = ((TextBox)row.FindControl( "txtPhoneN o")).Text;
string FaxNo = ((TextBox)row.FindControl( "txtFaxNo" )).Text;
try
{
List<ParameterDefinition> inParams = new List<ParameterDefinition>( );
inParams.Add(new ParameterDefinition("RowId ", DbType.Int64, Int64.Parse(RowId.ToString ())));
inParams.Add(new ParameterDefinition("Pharm acyName", DbType.String, PharmacyName));
inParams.Add(new ParameterDefinition("Addre ss1", DbType.String, Address1));
inParams.Add(new ParameterDefinition("Addre ss2", DbType.String, Address2));
inParams.Add(new ParameterDefinition("City" , DbType.String, City));
inParams.Add(new ParameterDefinition("State ", DbType.String, State));
inParams.Add(new ParameterDefinition("Zip", DbType.String, Zip));
inParams.Add(new ParameterDefinition("Phone No", DbType.String, PhoneNo));
inParams.Add(new ParameterDefinition("FaxNo ", DbType.String, FaxNo));
DataAccess.ExecuteProcedur e("DataCon nection", "CallList_Update", inParams);
gvCallList.EditIndex = -1;
Match();
BindCallList();
}
catch (Exception ex)
{
System.Diagnostics.Debug.W riteLine(e x.Message) ;
}
}
here are the two events in play:
protected void gvCallList_RowEditing(obje
{
gvCallList.EditIndex = e.NewEditIndex;
BindCallList();
}
protected void gvCallList_RowUpdating(obj
{
int idx = gvCallList.EditIndex;
GridViewRow row = gvCallList.Rows[idx];
string RowId = gvCallList.DataKeys[idx].V
string PharmacyName = ((TextBox)row.FindControl(
string Address1 = ((TextBox)row.FindControl(
string Address2 = ((TextBox)row.FindControl(
string City = ((TextBox)row.FindControl(
string State = ((TextBox)row.FindControl(
string Zip = ((TextBox)row.FindControl(
string PhoneNo = ((TextBox)row.FindControl(
string FaxNo = ((TextBox)row.FindControl(
try
{
List<ParameterDefinition> inParams = new List<ParameterDefinition>(
inParams.Add(new ParameterDefinition("RowId
inParams.Add(new ParameterDefinition("Pharm
inParams.Add(new ParameterDefinition("Addre
inParams.Add(new ParameterDefinition("Addre
inParams.Add(new ParameterDefinition("City"
inParams.Add(new ParameterDefinition("State
inParams.Add(new ParameterDefinition("Zip",
inParams.Add(new ParameterDefinition("Phone
inParams.Add(new ParameterDefinition("FaxNo
DataAccess.ExecuteProcedur
gvCallList.EditIndex = -1;
Match();
BindCallList();
}
catch (Exception ex)
{
System.Diagnostics.Debug.W
}
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER