Adding extra gridview rows from footer template

[bJames]

Hi
I've been all around looking for an answer to this question, but can't find it.
I've got a gridview with a single unbound column. It's got a textbox and button in the footer row. I"m trying to get the value from the textbox to add to the gridview on the button click. After trying to integrate other solutions into my code I've come up with this garbled mess in the button click event:


DataTable paramValues = new DataTable();
DataColumn ParameterValue = new DataColumn("Value", typeof(string));
paramValues.Columns.Add(ParameterValue);
foreach (GridViewRow row in gdvNewParameterValues.Rows)
{
paramValues.Rows.Add(row.Cells[0].ToString());
}
TextBox value = (TextBox)gdvNewParameterValues.FooterRow.Cells[0].FindControl("txtNewParameterValue");
TableCell tc = new TableCell();
tc.Text = value.Text;
TableRow tr = new TableRow();
tr.Cells.Add(tc);
paramValues.Rows.Add(tr);


gdvNewParameterValues.DataSource = paramValues;
gdvNewParameterValues.DataBind();


Any ideas?

[dillera1]

On the button click event (the button you have in the footer row) do the following...it'll look something like this:

protected void btnSubmitFooterRow_Click(object sender, EventArgs e)
{
Textbox newValue = (Textbox)datatableName.FooterRow.FindControl("txtb xName");
this.sqlDSName.InsertParameters["@valueInSQLDSName"].DefaultValue = newValue.Text;
this.sqlDSName.Insert();
datatableName.Databind();
}

This should help you out some....