how to read all rows from gridview using for loop?

Question

Iftikar Hussain · Answer

Hi, Do you want to loop thru all rows or only some selected rows? Since the code you have paste, you are doing selection and insertion to database. I suggest don't do sql operation in a loop. If your grid has got 1000 record, then that number of times will hit to database. Please let me know what exactly you want to do. Regards, Iftikar

Sanjeeb Lenka · Answer

check this link http://stackoverflow.com/questions/6185800/using-foreach-for-insert-gridview-data-into-sql-database

Hardik Patel · Answer

try { DataTable dtFinal = (DataTable)ViewState["InwardTable"]; // value pass through viewstate. for (int i = 0; i { string query = ""; query += "Select PendingQuantity from [WOInwardEntry] iw where iw.WOCode = " + ddWONumber.SelectedItem.Value + " and iw.DescriptionCode = '" + dtFinal.Rows[i]["ItemCode"].ToString() + "' order by PendingQuantity asc"; SqlCommand cmdInward = new SqlCommand(query, cn); SqlDataAdapter da = new SqlDataAdapter(cmdInward); DataSet ds = new DataSet(); da.Fill(ds); query = ""; query += "Select OrderQuantity from [Description] des where des.DescriptionCode = " + dtFinal.Rows[i]["ItemCode"].ToString() + " and des.WOCode = " + ddWONumber.SelectedItem.Value + ""; SqlCommand cmdQuantity = new SqlCommand(query, cn); SqlDataAdapter daQuantity = new SqlDataAdapter(cmdQuantity); DataSet dsQuantity = new DataSet(); daQuantity.Fill(dsQuantity); int OrderQuantity = Convert.ToInt32(dsQuantity.Tables[0].Rows[0]["OrderQuantity"]); if (ds.Tables[0].Rows.Count == 0) { PendingQuantity = OrderQuantity; } else { PendingQuantity = Convert.ToInt32(ds.Tables[0].Rows[0]["PendingQuantity"]); } string sp = "InsertWOInwardEntry"; cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandText = sp; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@WOCode", SqlDbType.Int).Value = Convert.ToInt32(ddWONumber.SelectedItem.Value); cmd.Parameters.Add("@SupplierCode", SqlDbType.Int).Value = Convert.ToInt32(ddSupplierName.SelectedItem.Value); cmd.Parameters.Add("@DescriptionCode", SqlDbType.Int).Value = Convert.ToInt32(dtFinal.Rows[i]["ItemCode"].ToString()); cmd.Parameters.Add("@InvoiceNo", SqlDbType.NVarChar).Value = txtInvoiceNo.Text.ToString(); cmd.Parameters.Add("@InvoiceDate", SqlDbType.Date).Value = Convert.ToDateTime(txtInvoiceDate.Text).ToString("yyyy-MM-dd"); cmd.Parameters.Add("@RecievedDate", SqlDbType.Date).Value = DBNull.Value; cmd.Parameters.Add("@InwardDate", SqlDbType.Date).Value = Convert.ToDateTime(txtInwardDate.Text).ToString("yyyy-MM-dd"); cmd.Parameters.Add("@Remarks", SqlDbType.NVarChar).Value = Convert.ToString(txtRemarks.Text); cmd.Parameters.Add("@InwardQuantity", SqlDbType.Int).Value = 0; cmd.Parameters.Add("@LastReceivedQuantity", SqlDbType.Int).Value = Convert.ToInt32(dtFinal.Rows[i]["Quantity"].ToString()); int inwardquantity = Convert.ToInt32(dtFinal.Rows[i]["Quantity"].ToString()); PendingQuantity = Convert.ToInt32(PendingQuantity - inwardquantity); cmd.Parameters.Add("@PendingQuantity", SqlDbType.Int).Value = PendingQuantity; ds = new DataSet(); da = new SqlDataAdapter(cmd); da.Fill(ds); if ((ds != null) && (ds.Tables.Count != 0) && (ds.Tables[0].Rows.Count != 0) && (ds.Tables[0].Rows[0]["Message"].ToString().ToLower() == "yes")) { lbNotify2.Text = "Inward Entry done!"; lbNotify2.ForeColor = System.Drawing.Color.Green; FillGDVInward(); } else { lbNotify2.Text = "Error while inserting Inward!"; lbNotify2.ForeColor = System.Drawing.Color.Red; FillGDVInward(); } ResetCommand(); }

Sanjeeb Lenka · Answer

hi hardic this code is for read the row value using the foreach loop. every gridview have columns with boundfield or template field so for reading the row you need to do like this. if any problem paste your code. we will solve your problem.

Hardik Patel · Answer

i just want to read all rows not column

Sanjeeb Lenka · Answer

The easiest would be using a foreach: foreach(GridViewRow row in GridView2.Rows) { //if using TemplateField columns then you may need to use FindControl method TextBox tb = (TextBox)row.FindControl("YourTextBoxID"); string someVariableName = tb.Text // get the value from TextBox //Otherwise if you are just using BoundField columns then you get the data directly like this string someVariableName = row.Cells[0].Text; //Where Cells is the column. Just changed the index of cells }