Visual Basic

Mycroft Holmes wrote:

I consider datareaders as part of the datatable/set infrastructure because dataset.fill uses a reader under the hood anyway.

lahsiv wrote:

If rs1.State = 1 Then rs1.Close()

supercat9 wrote:

DataWriter objects

supercat9 wrote:

Using INSERT and UPDATE queries isn't particularly difficult

Mycroft Holmes wrote:

Whats a datawriter?

Mycroft Holmes wrote:

How else do you get the data to and from a database?

1. Delete the old record and write a new one.
2. Try an 'Update' on the serial number, and if no records were updated, do an 'Insert'.

supercat9 wrote:

doing bulk-data inserts into a cursor or something

supercat9 wrote:

is there a good way to specify,

    For Each dr In dt.Rows
        ' Dim Myarray As String
        a = (dr("StartDateTime").ToString())
        Dim timeSpanDiff1 As TimeSpan = a.Subtract(start_display_datetime) '//hours difference
        Dim mins1 As Integer = timeSpanDiff1.Hours * 60 + timeSpanDiff1.Minutes '//total minutes
        start_cell_number = mins1 / 15 '//count number of cells
        ' Label1.Text = start_cell_number
        'Response.Write(start_cell_number.ToString() + "</br>")
        b = (dr("EndDateTime").ToString())
        Dim timeSpanDiff2 As TimeSpan = b.Subtract(start_display_datetime)                 Dim mins2 As Integer = timeSpanDiff2.Hours * 60 + timeSpanDiff2.Minutes
        end_cell_number = mins2 / 15 '//count number of cells
        Label1.Text = (dr("User_Name").ToString())
        For i = start_cell_number To end_cell_number
            testarray(i) = (dr("User_Name").ToString())
        Next
    Next


   <code> Dim noOfTimes As Integer = 0
     For Each str As String In testarray
    If Str = Label1.Text Then
    noOfTimes = noOfTimes + 1
    End If
      Next

    Response.Write(noOfTimes.ToString() + "" + Label1.Text)</code>

    For d = 0 To 31
        Dim tbcell As TableCell = New TableCell
        If testarray(d) = Nothing Then
            tbcell.BackColor = Color.Yellow
        Else
            tbcell.BackColor = Color.Green
            tbcell.ColumnSpan = noOfTimes
        End If

        tbcell.Text = "&nbsp;"
        trow.Cells.Add(tbcell)
    Next
    Table1.Rows.Add(trow)

Next

ershad wrote:

Is it okey if i pass id address and userid,password in connection string in .net application?

Christian Graus wrote:

Most intelligent people would write a webservice to do this.

Christian Graus wrote:

What web service ?