0

So I have a Datatable that is supposed to show information. I have it working in Windows Forms but tranfering it over to asp.net so a little diffrent. I do not understand GridViews that much. So any help would be appreciative.

I will not give everything away. I did a break and noticed that all the information was getting recieved but the gridview was not showing up. All of this is on page load.

dr = dt.NewRow();
        try
        {
            dt.Rows.Clear();
            dt.Rows.Clear();
            dt.Rows.Clear();
            dt = new DataTable("MyTable");
            dt.Columns.Add("Scale");
            dt.Columns.Add("Cases");
            dt.Columns.Add("Cases2", Type.GetType("System.String"));
            dt.Columns.Add("Cases3", Type.GetType("System.String"));
            dt.Columns.Add("Cases4", Type.GetType("System.String"));
            dt.Columns.Add("Cases5", Type.GetType("System.String"));
            dt.Columns.Add("Cases6", Type.GetType("System.String"));
            dt.Columns.Add("Cases7", Type.GetType("System.String"));
            dt.Columns.Add("Cases8", Type.GetType("System.String"));
            dt.Columns.Add("Cases9", Type.GetType("System.String"));
            dt.Columns.Add("Cases10", Type.GetType("System.String"));



            List<ManifestData> Data = GetManifestData(Start);
            if (Data != null && Data.Count > 0)
            {
                List<Standards> Standards = GetStandards(Data);

                //get scale numbers
                var a = (from d in Data select d.Scale).Distinct();

                //sort by scale where it will be displayed in order
                a = a.OrderBy(z => z.Value);

                TimeSpan t1 = new TimeSpan(), t2 = new TimeSpan(), t3 = new TimeSpan(), t4 = new TimeSpan(),
                         t5 = new TimeSpan(), t6 = new TimeSpan();
                foreach (int i in a)
                {
                    //get percentages for each scale
                    ScaleData s = GetPercentages(Data, Standards, i);

                    if (s != null)
                    {
                        if (s.ActualTarget != 0 && s.AdjustedTarget != 0)
                        {
                            //display percentages for scale
                            GridView1.Rows.Add = (new object[] { -info });

                        }

                       GridView2.Rows.Add(new object[] { -info }
                        t1 += s.ActualTime;
                        t2 += s.AdjustedTime;
                        t3 += s.ActualTimeWithChangeOvers;
                        t4 += s.AdjTimeWithChangeOvers;
                        t5 += (s.ActualTimeWithChangeOvers - s.ActualTime);
                        t6 += (s.ActualTimeWithChangeOvers - s.AdjTimeWithChangeOvers);

                    }
                }
                //add totals line
                if (GridView2.Rows.Count > 0)
                {
                    double cases = 0, target = 0, target2 = 0;
                    foreach (GridViewRow r in GridView2.Rows)
                    {
                       -info
                    }

                    GridView2.Rows.Add(new object[] { -info });
                }

                if (GridView2.Rows.Count > 0)
                {
                    int cases = 0, changeovers = 0;

                    foreach (GridViewRow r in GridView2.Rows)
                    {
                        -info
                    }

                    GridView2.Rows.Add(new object[] { -info});
                }

            }
            else
            {

            }
        }
        catch (Exception ex)
        {
            Label1.Text = "Error" + ex;   
        }

I deleted a lot of things and just put -info. You dont really need the code I believe. Just need help with things like Gridview.Rows.Add

 cases += Convert.ToInt32(r.Cells[1].Value.ToString());
                        changeovers += Convert.ToInt32(r.Cells[2].Value.ToString());

.Value does not work.

Any help would be awesome.

Thanks.

1
Contributor
1
Reply
17
Views
4 Years
Discussion Span
Last Post by Kratoswoo
0

Fgured it out needed to make some Columns in the code. Worked out.

Thanks.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.