store gridview footer row to gridview

ramya t

hi,

I am using gridview which contains html input textbox rather than asp:textbox,

how to refer the id from gridview and how to store this textbox values to gridview.

i have attached my code here.please help me to resolve this problem.

c# coding

HtmlInputText rc = ((HtmlInputText)gridView.FooterRow.FindControl("totalcost"));
HtmlInputText fpoc = ((HtmlInputText)gridView.FooterRow.FindControl("finalcost"));
MySqlCommand cmd = new MySqlCommand("insert into received values('" + l1.Text + "','" + lsid.Text + "','" + lod.Text + "','" +lf.Value + "','" + rc+ "','" +fpoc + "')", con);
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Received sucessfully');window.location ='ReceivedProduct.aspx';", true);
con.Close();

output

O.No S.id date pcost Rejectcost Final pcost

PO1000101

Supp1

24/11/2016

850

after that code executed the above output will displayed,i need rejected cost and final cost value also.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

ramya t9y ago
hi,

function addAllCost() {
var costArray = document.getElementsByName("RC");
var total = 0;
for (var i = 0; i < costArray.length; i++) {
total = total + parseInt(costArray[i].value);
}
$('#totalcost').val(total);

var finalpoamount = parseInt($('#lf').val());
var fop = finalpoamount - total;
$('#finalcost').val(fop);

}
this is javascript code for calculation.apart from that i am using c# code for save the gridview columns in databse.

HtmlInputText rc = ((HtmlInputText)gridView.FooterRow.FindControl("totalcost"));
HtmlInputText fpoc = ((HtmlInputText)gridView.FooterRow.FindControl("finalcost"));
MySqlCommand cmd = new MySqlCommand("insert into received values('" + l1.Text + "','" + lsid.Text + "','" + lod.Text + "','" +lf.Value + "','" + rc+ "','" +fpoc + "')", con);
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Received sucessfully');window.location ='ReceivedProduct.aspx';", true);
con.Close();

so both code was performed different action.this is not a problem,i think the problem is refer the footer row id of two input textboxes.
0
Joginder Banger9y ago
In above code no java script code seen. what type of error occur.
0
Joginder Banger9y ago
input type control worked on client side and you are trying to find control server side. so in general not possible but if you some change in input type control.

simple html control.
<input type="text" text="your values" />
after modification HTML control
<input type='text' id="totalcost" runat="server" name='TC' class='textbox'/>
am not sure get footer control but you can try this way.
if (gridview1.Rows.Count > 0)
{
    for (int i = 0; i < gridview1.Rows.Count; i++)
    {
        HtmlInputControl txt1 = (HtmlInputControl)gridview1.Rows[i].Cells[0].FindControl("txtNum");
        txt1.Attributes["type"] = "tel";
    }
}
another way.
int total = 0;
protected void gvEmp_RowDataBound(object sender, GridViewRowEventArgs e)
{
if(e.Row.RowType==DataControlRowType.DataRow)
{
total += Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "Amount"));
}
if(e.Row.RowType==DataControlRowType.Footer)
{
HtmlInputcontrol lblamount = (HtmlInputControl)e.Row.FindControl("lblTotal");

}
}
I hope you got some idea how to achieve this task.
0