Adding Columns in a Gridview

Chris Johnson

5y829Learn iOS Programming

Hi all.

I hope someone can help me.

I have a gridview with 6 Columns. Firstly I added the sixth using a template field "Available".

Simply I wish to do a sum QLOHLQ - QLALLQ and display that in the Available template field.

I have trawled the web and there seem to be a miriad of ways of doing this and I'm at the point of confusion.

Could someone possibly help me please?

4 Replies

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

Sachin Singh5y ago
Accepted answer
It is as simple as this
               "ITNOLQ" HeaderText="Item Number" SortExpression="ITNOLQ" />
               "WHLCLQ" HeaderText="Location" SortExpression="WHLCLQ" />
               "QLOHLQ" HeaderText="Quantity" SortExpression="QLOHLQ" />
               "QLALLQ" HeaderText="Allocated" SortExpression="QLALLQ" />
               "ORDRLQ" HeaderText="Order Number" SortExpression="ORDRLQ" />
               "New Count" ItemStyle-HorizontalAlign="Center" >

                   "Available"  Width="20" runat="server" Text='

<%Convert.Int32(Eval("QLOHLQ")-Convert.Int32(Eval("QLALLQ")'%>'
Now simply Bind your Grid normally
string cs = ConfigurationManager.ConnectionStrings["myConnection"].ConnectionString;
  using (SqlConnection con = new SqlConnection(cs))
   {
    connection.Open();
    SqlCommand cmd = new SqlCommand("Select * from Table", con);
    using (SqlDataReader rdr = cmd.ExecuteReader())
    {
        GridView1.DataSource = rdr;
        GridView1.DataBind();
    }
  }
Chris Johnson5y ago
Hi Satchin,
You were VERY close which put me on the right track.
The actual answer was this.
"Available" Width="20" runat="server">
<%# Convert.ToInt32(Eval("QLOHLQ"))- Convert.ToDouble(Eval("QLALLQ")) %>
<%----%>
Thank you for your help ;-)
Sachin Singh5y ago
I had missed , two brackets and The ToString() method. please test now.
               "ITNOLQ" HeaderText="Item Number" SortExpression="ITNOLQ" />
               "WHLCLQ" HeaderText="Location" SortExpression="WHLCLQ" />
               "QLOHLQ" HeaderText="Quantity" SortExpression="QLOHLQ" />
               "QLALLQ" HeaderText="Allocated" SortExpression="QLALLQ" />
               "ORDRLQ" HeaderText="Order Number" SortExpression="ORDRLQ" />
               "New Count" ItemStyle-HorizontalAlign="Center" >

                   "Available"  Width="20" runat="server"

Text='<%((Convert.Int32(Eval("QLOHLQ"))-Convert.Int32(Eval("QLALLQ"))).ToString() %>'
Chris Johnson5y ago
Hi Sachin,
Thanks very much for your reply.
However, using your code causes many errors.
I have solved the first part i think.
   "Available"  Width="20" runat="server" Text="'"
         <%Convert.ToInt32(Eval("QLOHLQ"))-Convert.ToInt32(Eval("QLALLQ"))'%>'>
But I still get the following 4 errors.

; Expected
Newline in Constant
Empty Character literal
;Expected

The server tag is not well formed.

Could you possibly help further?