forum

home / developersection / forums / generate daterow for every row in a dataset

Ask Question

Generate DateRow for every row in a dataset

Jayden Bell 2360 23-Aug-2014 
Dim diaryreader As SqlDataReader
diarycmd.CommandText = "dashboardusers"
diarycmd.CommandType = CommandType.StoredProcedure
diarycmd.Connection = usersconn
diaryconn.Open()
diaryreader = diarycmd.ExecuteReader() 
Dim diaryTable As DataTable = New DataTable()
diaryTable.Load(diaryreader)
Dim dr As DataRow
for each (dr in diaryTable.rows)

Next

This is not working, I am getting a syntax error when i try to do for each dr in diarytable.rows

vb.net vb.net 
Updated on 06-Jul-2023
Jayden Bell

Other

Message
Can you answer this question?
Answer

2 Answers

Aryan Kumar

Aryan Kumar

06-Jul-2023

Sure, I can help you with that. Here is an example of how to generate a daterow in a dataset:

VB.Net

Imports System.Data

Sub Main()
    ' Create a new DataTable object.
    Dim dataTable As New DataTable("DateTable")

    ' Add a Date column to the DataTable object.
    dataTable.Columns.Add("Date", GetType(DateTime))

    ' Generate a daterow in the DataTable object.
    Dim daterow As DataRow = dataTable.NewRow()
    daterow("Date") = DateTime.Now

    ' Add the daterow to the DataTable object.
    dataTable.Rows.Add(daterow)

    ' Display the contents of the DataTable object.
    Dim rows As DataRowCollection = dataTable.Rows
    For Each row As DataRow In rows
        Console.WriteLine(row("Date"))
    Next
End Sub

This code will create a new DataTable object and add a Date column to it. The code will then generate a daterow in the DataTable object and add it to the DataTable object. Finally, the code will display the contents of the DataTable object on the console.

Here is an explanation of the code:

  • The DataTable class represents a DataTable object.
  • The Columns property of the DataTable class gets the collection of columns for the DataTable object.
  • The Add method of the Columns property adds a column to the collection.
  • The NewRow method of the DataTable class creates a new DataRow object.
  • The Date property of the DataRow class sets the value of the Date column.
  • The Rows property of the DataTable class gets the collection of rows for the DataTable object.
  • The Add method of the Rows property adds a row to the collection.
  • The Console.WriteLine method is used to print the contents of the DataTable object on the console.
Sumit Kesarwani

Sumit Kesarwani

23-Aug-2014
Hi Jayden, 

You get errors because your braces are set wrong. This would work:

Dim dr As DataRow

For Each dr In diaryTable.Rows

Next

MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy