how to add two columns and display in Grid view ?

Kamala Veni

Hi..

I am having sql table in dat am having two column name A and B .these two row values added and show in the c label as total value and dat grand total too plz help me

model:

A B C

3 4 7

1 1 2

4 5 9

total:18 (C total)

ex:

am having for add 1 column oly but i need for two columns:

ForeColor="Black" ShowFooter="TRUE" OnRowDataBound="GridView1_RowDataBound"

Width="1108px" Height="224px" style="margin-right: 0px; margin-top: 0px; margin-left: 209px; text-align: left;">

TOTAL

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

Label lblqy = (Label)e.Row.FindControl("lblqty");

int qty = Int32.Parse(lblqy.Text);

total = total + qty;

}

if (e.Row.RowType == DataControlRowType.Footer)

{

Label lblTotalqty = (Label)e.Row.FindControl("lblTotalqty");

lblTotalqty.Text = total.ToString();

}

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["App"].ToString());

DataTable dt = new DataTable();

SqlDataAdapter da = new SqlDataAdapter("select COMPANYNAME,HTSCNO,EDC,DRAWALVOLT,(CPPQUANTUM_C) from TBL_CPPMASTER WHERE DRAWALVOLT like '%%' ", con);

DataSet ds = new DataSet();

int i = 0;

string sql = null;

string connetionString = "data source=VAAYUSEVA_SVR;Initial Catalog=cppsch;User ID=sa;Password=sa";

con.Open();

da.Fill(dt);

con.Close();

if (dt.Rows.Count > 0)

{

Grd1.DataSource = dt;

Grd1.DataBind();

}

4 Replies

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

Amit Gupta10y ago
Hi kamala,

Yes ofcourse you can perform grand total of the column. Here it is
Label.Text = dataset.Tables [0].Compute ("sum (columnName)");

To show output in a seperate columnn, add another column to the dataset and set its expression like this.

// adding column
Dataset.Tables [0].Columns.Add ("total").Expression ="sum ("columnName");

//when ur dataset is filled, u will get total column with sum of your column.

Hope it helps
Shakti Singh Dulawat10y ago
Yes for that you need to add a run time Sum column in your datatable please follow http://stackoverflow.com/questions/2786771/how-to-make-addition-of-two-columns-data-for-another-column-where-those-two-colu
Kamala Veni10y ago
This query is working in sql oly ,bt i need to built this in c# and show output in gridview, insteadof creating a total column,cnt get the outpt directly...can ???
Shakti Singh Dulawat10y ago
My Suggestions change your SQL and you will have another column
SELECT
Val1,
Val2,
Val3,
(Val1+Val2+Val3)as'Total'
FROMEmp