谁能解决我的问题? [英] Can anyone solve my problem?

问题描述

在DataGridView中，我像10:00 am-01:00pm,02:00pm-03:00pm那样保存了时间栏.如果我单击网格值，则它会转换为数据表.很好.
假设如果我更新了一些诸如Age，Name等的值并单击update表示，则Gridview在Timings列中具有空值.
使用此代码再次更新到时序列

In DataGridView I saved like 10:00am-01:00pm,02:00pm-03:00pm for timings column. If i click grid values,it is comint to the datatable. That''s fine.
Suppose if i update some values like Age,Name etc and click update means, Gridview is having null values in Timings column.
Used this code to update again to datagridview for timing column,

Dim totaltime As String = ""
   Dim i As Integer
   For i = 0 To Carer.dt.Rows.Count - 1
     If i = 0 Then
     totaltime += Carer.dt.Rows(i)("TimeFrom").ToString() + "-" + Carer.dt.Rows(i)("TimeTo").ToString()
     Else
     totaltime += "," + Carer.dt.Rows(i)("TimeFrom").ToString() + "-" + Carer.dt.Rows(i)("TimeTo").ToString()
     End If
   Next

的datagridview 请事先帮助我


[edit]删除了虚假的代码块-OriginalGriff [/edit]

Please help me thanks in advance


[edit]Spurious code block removed - OriginalGriff[/edit]

推荐答案

您必须确保要提取数据的列本身不是无效的.请记住，它是在我的头顶上键入的，因此您可能需要对其进行调整.

You have to make sure that the columns you''re trying to extract data from are not themselves null. Keep in mind this was typed off the top of my head, so you may need to tweak it.

Dim totalTime As String = ""
For i = 0 To Carer.dt.Rows.Count - 1
    Dim timeFrom as String = ""
    Dim timeTo as String = ""

    if (Not IsDBNull(Carer.dt.Rows(i)("TimeFrom")) Then
        timeFrom = Carer.dt.Rows(i)("TimeFrom").ToString()
    End If
    if (Not IsDBNull(Carer.dt.Rows(i)("TimeTo")) Then
        timeTo = Carer.dt.Rows(i)("TimeTo").ToString()
    End If

    If (Not string.IsNullOrEmpty(totalTime)) Then
        totalTime += ","
    EndIf
    totaltime += string.Format("{0}-{1}", timeFrom, timeTo)
Next

最后，使用调试器将帮助您解决问题.

Finally, using the debugger would have help you solve the issue.

这篇关于谁能解决我的问题?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！