Wednesday, October 31, 2007

Save the Grid Item

foreach(DataGridItem dgItem in dg_ProposedExp.Items)
{
Label Sno=(Label)dgItem.Cells[0].FindControl("Lbl_Sno");
Label Description =(Label)dgItem.Cells[1].FindControl("Lbl_Description");
Label Unit = (Label)dgItem.Cells[2].FindControl("Lbl_Unit");
Label Qty = (Label)dgItem.Cells[3].FindControl("Lbl_Qty");
Label Rate = (Label)dgItem.Cells[4].FindControl("Lbl_Rate");
Label Amount = (Label)dgItem.Cells[5].FindControl("Lbl_Amount");
PE_save="Insert into Proposed_Expenditure values('"+IE_ID+"','"+Sno.Text+"','"+Description.Text+"','"+Unit.Text+"','"+Qty.Text+"','"+Rate.Text+"','"+Amount.Text+"')";
SqlCommand sqlcmd_dg=new SqlCommand(PE_save,sqlcon_save);
sqlcmd_dg.ExecuteNonQuery();
}

No comments: