Select Specific Column in Gridview Template Field using Loop in C#

Please i have the below code that upon button click event, i create a delimited string from a gridview and display it in a textbox. Currently the loop creates the delimited string using all the columns available in the gridview.Now my task is to

Use template textbox field inside the gridview instead of the normal gridview default
I don't need all the columns to create the delimited string.I need Specific columns Only. So now do how i specify only the columns i need to create the delimited string using template textbox fields. Per the image below i don't want the storeid column to be part of the delimited string

Below is also the working code which does not use template fields

protected void CreatePOEntryString2()
{
{
string MyResults = "";
foreach (GridViewRow gRow in griditem.Rows)
{
if (MyResults != "")
MyResults += "|";
string MyRow = "";
foreach (TableCell tCell in gRow.Cells)
{
if (MyRow != "")
MyRow += ",";
MyRow += tCell.Text;
}
MyResults += MyResults;
}
txtPODetails.Text = MyResults + ItemPipe;
}
}

Thank you

1 Reply

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

Sachin Singh5y ago
there are multiple ways to not show the undesired column
Method1. hide the undesired column.
protected void GridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
    e.Row.Cells[index].Visible = false;
}
method 2.use ItemTemplate field
"GridView4" runat="server" AutoGenerateColumns="False"CellPadding="4" ForeColor="#333333" GridLines="None">

"firstname" HeaderText="firstname" SortExpression="firstname" />
"lastname" HeaderText="lastname" SortExpression="lastname" />


Now bind the gridview in code behind , write command to select only the columns you need.