Can anyone solve my problem?

Question

4.00/5 (1 vote)

See more:

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

Please help me thanks in advance

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

Posted 10-Jun-11 7:45am

hemantwithu

Updated 10-Jun-11 9:15am

OriginalGriff

v3

Add a Solution

1 solution

Add a Solution

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

#realJSOP · Accepted Answer · 2011-06-10T09:23:00

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.

VB

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.

Can anyone solve my problem?

1 solution

Solution 1

Add your solution here

Preview 0

Can anyone solve my problem?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us