Click here to Skip to main content
15,891,864 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
Hi,
I am now blank with this issue. After loading the whole data, all the rows are showing blank in grid. Here is my code..
Please help out where I am doing mistake…all the rows been filled in grid are showing blank..
Grid definition…

XML
<sdk:DataGrid  Name="dgrIncidents"   AutoGenerateColumns="False"  HeadersVisibility="All"
                                                RowBackground="Cornsilk" AlternatingRowBackground="LemonChiffon"
                                                 IsReadOnly="True" CanUserResizeColumns="True" GridLinesVisibility="All">
                            <sdk:DataGrid.Columns>
                                <sdk:DataGridTextColumn CanUserReorder="True" CanUserResize="True" CanUserSort="True" Width="Auto" Header="Reported Date" Binding="{Binding Reported_Date}"/>
                                <sdk:DataGridTextColumn CanUserReorder="True" CanUserResize="True" CanUserSort="True" Width="Auto" Header="Incident ID" Binding="{Binding Incident_ID}"/>
                                <sdk:DataGridTextColumn CanUserReorder="True" CanUserResize="True" CanUserSort="True" Width="Auto" Header="Closed Date" Binding="{Binding Closed_Date}"/>
                                <sdk:DataGridTextColumn CanUserReorder="True" CanUserResize="True" CanUserSort="True" Width="Auto" Header="Last Resolved Date" Binding="{Binding Last_Resolved_Date}"/>
                                <sdk:DataGridTextColumn CanUserReorder="True" CanUserResize="True" CanUserSort="True" Width="Auto" Header="Assigned Group" Binding="{Binding Assigned_Group}"/>
                                <sdk:DataGridTextColumn CanUserReorder="True" CanUserResize="True" CanUserSort="True" Width="Auto" Header="Assignee" Binding="{Binding Assignee}"/>
                                <sdk:DataGridTextColumn CanUserReorder="True" CanUserResize="True" CanUserSort="True" Width="Auto" Header="Status" Binding="{Binding Status}"/>
                                <sdk:DataGridTextColumn CanUserReorder="True" CanUserResize="True" CanUserSort="True" Width="Auto" Header="Summary" Binding="{Binding Summary}"/>
                            </sdk:DataGrid.Columns>
                        </sdk:DataGrid>

Back code
C#
void lFnLoadDataInGrid()
        {
            try
            {
                lFnStartWait();
                dgrIncidents.ItemsSource = lFnLoadCSVDataInGrid();
                lFnStopWait();
            }
            catch (Exception)
            {

                throw;
            }
        }


        List<clsGridLoadExcelData> lFnLoadCSVDataInGrid()
        {
            try
            {
                if (Prp_Opendialogue.File == null)
                {
                    lFnShowPopupErr("Please select CSV file");
                    return null;
                }

                List<clsGridLoadExcelData> lArrObjclsGridLoadExcelData = new List<clsGridLoadExcelData>();

                StreamReader lObjStreamReader = new StreamReader(Prp_Opendialogue.File.OpenRead());

                bool lBlnIsColumnRow = true;

                while (lObjStreamReader.Read() != null)
                {
                    string lStrLine = lObjStreamReader.ReadLine();

                    if (lBlnIsColumnRow)
                    {
                        lBlnIsColumnRow = false;
                        continue;
                    }

                    if (lStrLine == null)
                        break;

                    if (lStrLine.Trim() == "")
                        continue;

                    string[] lArrStrCells = null;

                    lArrStrCells = lStrLine.Split(",".ToCharArray());

                    if (lArrStrCells == null)
                        continue;

                    if (!(lArrStrCells.Length == 8))
                        continue;

                    clsGridLoadExcelData lObjclsGridLoadExcelData = new clsGridLoadExcelData();

                    lObjclsGridLoadExcelData.Reported_Date = lArrStrCells[0];
                    lObjclsGridLoadExcelData.Incident_ID = lArrStrCells[1];
                    lObjclsGridLoadExcelData.Closed_Date = lArrStrCells[2];
                    lObjclsGridLoadExcelData.Last_Resolved_Date = lArrStrCells[3];
                    lObjclsGridLoadExcelData.Assigned_Group = lArrStrCells[4];
                    lObjclsGridLoadExcelData.Assignee = lArrStrCells[5];
                    lObjclsGridLoadExcelData.Status = lArrStrCells[6];
                    lObjclsGridLoadExcelData.Summary = lArrStrCells[7];

                    lArrObjclsGridLoadExcelData.Add(lObjclsGridLoadExcelData);
                }

                lObjStreamReader.Close();
                lObjStreamReader.Dispose();

                return lArrObjclsGridLoadExcelData;
            }
            catch (Exception ex)
            {
                lFnShowPopupErr(ex.Message.ToString());
                return null;
            }
        }

   class clsGridLoadExcelData
        {


            public string Reported_Date { get; set; }
            public string Incident_ID { get; set; }
            public string Closed_Date { get; set; }
            public string Last_Resolved_Date { get; set; }
            public string Assigned_Group { get; set; }
            public string Assignee { get; set; }
            public string Status { get; set; }
            public string Summary { get; set; }



        }

Thanks
Sreenath
Posted
Updated 11-May-11 21:20pm
v3
Comments
Dalek Dave 12-May-11 3:20am    
Edited the code blocks.
humrahimcs1122 21-Feb-12 10:24am    
thanks dear for help to resolve my problem.

You need to set the ItemsSource of the data grid to the underlying collection - in this case lArrObjclsGridLoadExcelData .
 
Share this answer
 
Comments
Sreenath Gv 12-May-11 2:47am    
yeah that what is List<clsgridloadexceldata> lFnLoadCSVDataInGrid() returns and I am assigning to
dgrIncidents.ItemsSource = lFnLoadCSVDataInGrid();
Dalek Dave 12-May-11 3:20am    
Good Call.
Abhinav S 12-May-11 4:44am    
Thanks
Sreenath Gv 12-May-11 4:25am    
but not working...
Sreenath Gv 12-May-11 4:25am    
still data in grid rows is blank...
Any update on this guys...didnt get solution yet..
 
Share this answer
 
Comments
Mark Salsbery 16-May-11 13:46pm    
Put a breakpoint on the lFnStopWait(); line. Examine dgrIncidents.ItemsSource. How many items are in the List? If more than zero, look at the items...are all the properties empty/null or do you see your values there?
Sreenath Gv 16-May-11 22:24pm    
hi, item source have got all the cell details in csv file..no null values. but even then rows are blank.
Mark Salsbery 17-May-11 3:10am    
What does "lFnStopWait();" do?

To rule out XAML error, maybe try just a simple DataGrid:

<sdk:DataGrid name="dgrIncidents" autogeneratecolumns="True" />
Got the solution...

hey just go through below link....it will show you how to bind datagrid with datasources like (dataset,datatable)

http://slbindabledatagrid.codeplex.com/


sol : 2

http://pastebin.com/f56674dfb
and then I adapted some code from this excellent idea:
http://blog.bodurov.com/blog/Post.aspx?postID=27
mashing it all together and eventually coming up with:
http://pastebin.com/fb64198e
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900