Can't insert a Column in DataGrid which DataSet does not Contain

[Terry]

All I'm doing, is using the Compute Method and getting the Sum of the Amount
field in my SQL Query. The problem is getting the Data Table to add a Column
and put the total in the "Total Column". I can see that I'm getting the data
I want, But can not display it. I could sure use the Help.
Thanks In Advance

THE CODE:
SqlDataAdapter da = new SqlDataAdapter( );
DataSet ds = new DataSet();
this.sqlConnect ion1.Open();
da.SelectComman d=scmd;
da.Fill(ds,"Glo bal");

DataGridTableSt yle tsl = new DataGridTableSt yle();
DataGridColumnS tyle TextCol = new DataGridTextBox Column();
TextCol.Mapping Name = "First";
TextCol.HeaderT ext = "First";
TextCol.Width = 150;

DataGridColumnS tyle COL = new DataGridTextBox Column();
COL.MappingName = "Last";
COL.HeaderText = "Last";
COL.Width = 150;
DataGridColumnS tyle MI = new DataGridTextBox Column();
MI.MappingName = "MI";
MI.HeaderText = "MI";
MI.Width = 25;

DataGridColumnS tyle Address = new DataGridTextBox Column();
Address.Mapping Name = "Address";
Address.HeaderT ext = "Address";
Address.Width = 150;

DataGridColumnS tyle Total = new DataGridTextBox Column();
Total.MappingNa me = ds.Tables["Global"].Compute("Sum(A mount)","Amount >
0").ToString ();
Total.HeaderTex t = "Total";
Total.Width = 25;

tsl.MappingName ="Global";

tsl.GridColumnS tyles.Add(TextC ol);
tsl.GridColumnS tyles.Add(COL);
tsl.GridColumnS tyles.Add(Total );
tsl.GridColumnS tyles.Add(MI);
tsl.GridColumnS tyles.Add(Addre ss);
tsl.GridColumnS tyles.Add(Total );

dgSummary.DataS ource=ds;
dgSummary.DataM ember="Global";
dgSummary.Table Styles.Add(tsl) ;
this.sqlConnect ion1.Close();

[W.G. Ryan eMVP]

Where are you adding the DataColumn? If you add the column to the Columns
collection and then just map a COlumnstyle to it, it should show
http://www.knowdotnet.com/articles/expressions.html

However compute works on aggregates so I'm not sure if you want the Total in
each column.

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Terry" <Te***@discussi ons.microsoft.c om> wrote in message
news:8F******** *************** ***********@mic rosoft.com...

All I'm doing, is using the Compute Method and getting the Sum of the Amount field in my SQL Query. The problem is getting the Data Table to add a Column and put the total in the "Total Column". I can see that I'm getting the data I want, But can not display it. I could sure use the Help.
Thanks In Advance

THE CODE:
SqlDataAdapter da = new SqlDataAdapter( );
DataSet ds = new DataSet();
this.sqlConnect ion1.Open();
da.SelectComman d=scmd;
da.Fill(ds,"Glo bal");

DataGridTableSt yle tsl = new DataGridTableSt yle();
DataGridColumnS tyle TextCol = new DataGridTextBox Column();
TextCol.Mapping Name = "First";
TextCol.HeaderT ext = "First";
TextCol.Width = 150;

DataGridColumnS tyle COL = new DataGridTextBox Column();
COL.MappingName = "Last";
COL.HeaderText = "Last";
COL.Width = 150;
DataGridColumnS tyle MI = new DataGridTextBox Column();
MI.MappingName = "MI";
MI.HeaderText = "MI";
MI.Width = 25;

DataGridColumnS tyle Address = new DataGridTextBox Column();
Address.Mapping Name = "Address";
Address.HeaderT ext = "Address";
Address.Width = 150;

DataGridColumnS tyle Total = new DataGridTextBox Column();
Total.MappingNa me = ds.Tables["Global"].Compute("Sum(A mount)","Amount >
0").ToString ();
Total.HeaderTex t = "Total";
Total.Width = 25;

tsl.MappingName ="Global";

tsl.GridColumnS tyles.Add(TextC ol);
tsl.GridColumnS tyles.Add(COL);
tsl.GridColumnS tyles.Add(Total );
tsl.GridColumnS tyles.Add(MI);
tsl.GridColumnS tyles.Add(Addre ss);
tsl.GridColumnS tyles.Add(Total );

dgSummary.DataS ource=ds;
dgSummary.DataM ember="Global";
dgSummary.Table Styles.Add(tsl) ;
this.sqlConnect ion1.Close();