Set NullValue for each row of GridViewDateTimeColumn in UI for WinForms

This is a migrated thread and some comments may be shown as answers.

Set NullValue for each row of GridViewDateTimeColumn

1 Answer 9 Views

GridView

This is a migrated thread and some comments may be shown as answers.

özer asked on 02 Jul 2020, 03:04 PM

screenshotffd5c6b50d5a4a7d9376a8caaa8c2473.png

Hi.

I take the table on a web page with C # and Selenium and show it in radGridView.
I add a GridViewCheckBoxColumn before the first column of each row, and I add GridViewDateTimeColumn and GridViewComboBoxColumn after the last column.
I want to equalize the initial value of the DatePicker object in GridViewDateTimeColumn to the value in column 7 of the row where it is located.

However, the initial value of DatePickers in all rows is equal to the value in the 7th column of the last row.

Here is my code:

01.public void FillRadGridView(List<IWebElement> rows, List<IWebElement> columns, int rowCount, int columnCount, RadGridView rgv)

02. {

03.

04. List<Visit> lst = new List<Visit>();

05. Visit v = new Visit();

06. for (int i = 0; i < rowCount; i++)

07. {

08. for (int j = 1; j <= columnCount; j++)

09. {

10.

11. v.Tckn = columns[1].Text;

12. v.AdSoyad = columns[2].Text;

13. v.Vaka = columns[3].Text;

14. v.RaporTakipNo = columns[4].Text;

15. v.RaporSiraNo = columns[5].Text;

16. v.RaporBaslamaTarihi = DateTime.Parse(columns[6].Text).ToShortDateString();

17. v.RaporBitisTarihi = DateTime.Parse(columns[7].Text).AddDays(-1).ToShortDateString();

18. v.IsBasiKontrolTarihi = DateTime.Parse(columns[7].Text).ToShortDateString();

19. v.CezaDurumu = columns[8].Text;

20.

21. }

22. lst.Add(v);

23. }

24. rgv.Columns.Clear();

25.

26. GridViewCheckBoxColumn checkBoxColumn = new GridViewCheckBoxColumn();

27. checkBoxColumn.DataType = typeof(int);

28. checkBoxColumn.Name = "ColumnSelect";

29. checkBoxColumn.FieldName = "select";

30. checkBoxColumn.HeaderText = "Seç";

31. rgv.Columns.Add(checkBoxColumn);

32.

33. rgv.DataSource = lst;

34. AddColumnToRgv(rgv);

35.

36. }

1 Answer, 1 is accepted

answered on 06 Jul 2020, 10:04 AM

Hello, özer,

According to the provided information, it is not clear enough what is the Telerik product that you are currently using since this is the forum related to the Telerik UI for WinForms suite but you mentioned "web page". I am providing an answer regarding the Telerik WinForms product. In case you are using another product, feel free to post your question in the relevant forum: https://www.telerik.com/forums

The provided information is also not enough to get full understanding of the precise case and the setup that you have. However, I will try to suggest a possible solution.

If you have an assigned value to a cell in GridViewDateTimeColumn, the cell is expected to show this value. Note that a GridViewDateTimeColumn offers the NullValue property. Thus, you specify what date value to be displayed within the cell if you have DBNull.Value or null.

            GridViewDateTimeColumn col1 = new GridViewDateTimeColumn("Date1");
            col1.NullValue = new DateTime(2020, 1, 1);
            this.radGridView1.Columns.Add(col1);

            GridViewDateTimeColumn col2 = new GridViewDateTimeColumn("Date2"); 
            this.radGridView1.Columns.Add(col2);

            this.radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;

            this.radGridView1.Rows.Add(DateTime.Now, DateTime.Now);
            this.radGridView1.Rows.Add(null, null);
            this.radGridView1.Rows.Add(DBNull.Value, DBNull.Value);
            this.radGridView1.Rows.Add(DateTime.Now.AddDays(-1), DateTime.Now.AddDays(-1));

If it is not the case or it doesn't fit your scenario, it would be greatly appreciated if you can provide more details about the exact goal that you are trying to achieve. Once we get better understanding of the precise case, we can about a suitable solution and provide further assistance. Thank you in advance for your cooperation.

I hope this information helps. If you need any further assistance please don't hesitate to contact me.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.