CODEWITHSUNDEEP
asp.netgridviewforeach
AddyProg
AddyProg

Reputation: 3050

Getting gridview data in variables and inserting it to database

I am making a shopping cart type of thing using grid view user will keep adding item in it after doing it so user will click save i want to get values from all columns of grid view each row at a time and save it to database.

here is the code for grid view load

  protected void add_Click(object sender, EventArgs e)
{

    product.Item = Item_Drop.SelectedItem.Text;
    product.Quantity = quantity_box.Text;
    int qun =Convert.ToInt32(quantity_box.Text);
    int unitP= Convert.ToInt32(unitPrice_box.Text);
    product.item_Toal = (qun*unitP).ToString();


    list.Add(product);

    temp_gridView.DataSource = list;
    temp_gridView.DataBind();

 }

And here is what i am trying to get values

    public void Values_from_grid()
{ 
  foreach(temp_gridView row in temp_gridView.Rows)
  {
   for(int i = 0; i < temp_gridView.Columns.Count, i++)
   {
    String header = temp_gridView.Columns[i].HeaderText;
    String cellText = row.Cells[i].Text;
   }
   }
 }

i am not getting any values in "header" or "cellText" . .. .

Upvotes: 0

Views: 2316

Answers (2)

AddyProg
AddyProg

Reputation: 3050

Found Answer no need to use

GridView.Rows.Count

just use a simple int to iterate 

int i = 0;
foreach(GridViewRow row in  temp_gridView.Rows)
{

box.Item_id = temp_gridView.Rows[i].Cells[0].Text;
box.Quantity = temp_gridView.Rows[i].Cells[1].Text;
box.Total = temp_gridView.Rows[i].Cells[2].Text;
i++;
}

Upvotes: 0

Raghubar
Raghubar

Reputation: 2788

Use this code to get header row value .

GridViewName.HeaderRow.Cells[0].Text;

Upvotes: 1

Related Questions