populate array with sql table data vb.net

[Sharon]

hello,

I wanted to populate an array with the data from sql table, but not
sure how to go about it.

This is the array iam using at present, but i dont want to provide the
values. Instead i want to query them from sql table t_holidays.

Dim HolidayList() As Date = {#7/4/2006#, #7/6/2006#, #7/13/2006#,
#7/19/2006#, #12/24/2006#, #12/25/2006#, #12/29/2006#, #1/1/2007#}

Any suggestions how to go about this one. Your time is greatly
appreciated.

cheers, Sharon.

[Milosz Skalecki]

Simple example (i assume you have basic knowledge about ADO.NET)

Imports System.Data
Imports System.Data.Sql Client

Partial Class _Default
Inherits System.Web.UI.P age

Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArg s) Handles Me.Load

Dim dates As System.Collecti ons.Generic.Lis t(Of DateTime) = GetDates()

End Sub

Private Const ConnectionStrin g As String =
"server=ServerN ame;uid=UserNam e;password=Pass word;database=D atebaseName"

Private Function GetDates() As System.Collecti ons.Generic.Lis t(Of DateTime)

Dim result As New System.Collecti ons.Generic.Lis t(Of DateTime)
Dim connection As New SqlConnection(C onnectionString )
Dim command As New SqlCommand("sel ect DateColumn FROM TableName WHERE
Condition", connection)
Dim reader As SqlDataReader

Try

connection.Open ()
reader = command.Execute Reader()

While reader.Read()
result.Add(read er.GetDateTime( 0))
End While

Catch ex As Exception
Throw ex
Finally
connection.Disp ose()
End Try

Return result

End Function

End Class
--
Milosz Skalecki
MCP, MCAD
"Sharon" wrote:

hello,

I wanted to populate an array with the data from sql table, but not
sure how to go about it.

This is the array iam using at present, but i dont want to provide the
values. Instead i want to query them from sql table t_holidays.

Dim HolidayList() As Date = {#7/4/2006#, #7/6/2006#, #7/13/2006#,
#7/19/2006#, #12/24/2006#, #12/25/2006#, #12/29/2006#, #1/1/2007#}

Any suggestions how to go about this one. Your time is greatly
appreciated.

cheers, Sharon.

[Sharon]

Thanks for the Reply, But its giving me an error

System.Collecti ons.Generic.Lis t is not defined, Please let me know
where did it went wrong.

cheers, Sharon.
Milosz Skalecki wrote:

Simple example (i assume you have basic knowledge about ADO.NET)

Imports System.Data
Imports System.Data.Sql Client

Partial Class _Default
Inherits System.Web.UI.P age

Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArg s) Handles Me.Load

Dim dates As System.Collecti ons.Generic.Lis t(Of DateTime) = GetDates()

End Sub

Private Const ConnectionStrin g As String =
"server=ServerN ame;uid=UserNam e;password=Pass word;database=D atebaseName"

Private Function GetDates() As System.Collecti ons.Generic.Lis t(Of DateTime)

Dim result As New System.Collecti ons.Generic.Lis t(Of DateTime)
Dim connection As New SqlConnection(C onnectionString )
Dim command As New SqlCommand("sel ect DateColumn FROM TableName WHERE
Condition", connection)
Dim reader As SqlDataReader

Try

connection.Open ()
reader = command.Execute Reader()

While reader.Read()
result.Add(read er.GetDateTime( 0))
End While

Catch ex As Exception
Throw ex
Finally
connection.Disp ose()
End Try

Return result

End Function

End Class
--
Milosz Skalecki
MCP, MCAD
"Sharon" wrote:

hello,

I wanted to populate an array with the data from sql table, but not
sure how to go about it.

This is the array iam using at present, but i dont want to provide the
values. Instead i want to query them from sql table t_holidays.

Dim HolidayList() As Date = {#7/4/2006#, #7/6/2006#, #7/13/2006#,
#7/19/2006#, #12/24/2006#, #12/25/2006#, #12/29/2006#, #1/1/2007#}

Any suggestions how to go about this one. Your time is greatly
appreciated.

cheers, Sharon.

[Sharon]

I am using .NET Framework version, is this class available in this
version
Milosz Skalecki wrote:

Simple example (i assume you have basic knowledge about ADO.NET)

Imports System.Data
Imports System.Data.Sql Client

Partial Class _Default
Inherits System.Web.UI.P age

Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArg s) Handles Me.Load

Dim dates As System.Collecti ons.Generic.Lis t(Of DateTime) = GetDates()

End Sub

Private Const ConnectionStrin g As String =
"server=ServerN ame;uid=UserNam e;password=Pass word;database=D atebaseName"

Private Function GetDates() As System.Collecti ons.Generic.Lis t(Of DateTime)

Dim result As New System.Collecti ons.Generic.Lis t(Of DateTime)
Dim connection As New SqlConnection(C onnectionString )
Dim command As New SqlCommand("sel ect DateColumn FROM TableName WHERE
Condition", connection)
Dim reader As SqlDataReader

Try

connection.Open ()
reader = command.Execute Reader()

While reader.Read()
result.Add(read er.GetDateTime( 0))
End While

Catch ex As Exception
Throw ex
Finally
connection.Disp ose()
End Try

Return result

End Function

End Class
--
Milosz Skalecki
MCP, MCAD
"Sharon" wrote:

hello,

I wanted to populate an array with the data from sql table, but not
sure how to go about it.

This is the array iam using at present, but i dont want to provide the
values. Instead i want to query them from sql table t_holidays.

Dim HolidayList() As Date = {#7/4/2006#, #7/6/2006#, #7/13/2006#,
#7/19/2006#, #12/24/2006#, #12/25/2006#, #12/29/2006#, #1/1/2007#}

Any suggestions how to go about this one. Your time is greatly
appreciated.

cheers, Sharon.

[Milosz Skalecki]

Howdy,

i automatically assumed you were using framework 2.0. Please use
System.Collecti ons.ArrayList instead of
System.Collecti ons.Generic.Lis t(Of DateTime)

regards

--
Milosz Skalecki
MCP, MCAD
"Sharon" wrote:

I am using .NET Framework version, is this class available in this
version
Milosz Skalecki wrote:

Simple example (i assume you have basic knowledge about ADO.NET)

Imports System.Data
Imports System.Data.Sql Client

Partial Class _Default
Inherits System.Web.UI.P age

Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArg s) Handles Me.Load

Dim dates As System.Collecti ons.Generic.Lis t(Of DateTime) = GetDates()

End Sub

Private Const ConnectionStrin g As String =
"server=ServerN ame;uid=UserNam e;password=Pass word;database=D atebaseName"

Private Function GetDates() As System.Collecti ons.Generic.Lis t(Of DateTime)

Dim result As New System.Collecti ons.Generic.Lis t(Of DateTime)
Dim connection As New SqlConnection(C onnectionString )
Dim command As New SqlCommand("sel ect DateColumn FROM TableName WHERE
Condition", connection)
Dim reader As SqlDataReader

Try

connection.Open ()
reader = command.Execute Reader()

While reader.Read()
result.Add(read er.GetDateTime( 0))
End While

Catch ex As Exception
Throw ex
Finally
connection.Disp ose()
End Try

Return result

End Function

End Class
--
Milosz Skalecki
MCP, MCAD
"Sharon" wrote:

hello,
>
I wanted to populate an array with the data from sql table, but not
sure how to go about it.
>
This is the array iam using at present, but i dont want to provide the
values. Instead i want to query them from sql table t_holidays.
>
Dim HolidayList() As Date = {#7/4/2006#, #7/6/2006#, #7/13/2006#,
#7/19/2006#, #12/24/2006#, #12/25/2006#, #12/29/2006#, #1/1/2007#}
>
Any suggestions how to go about this one. Your time is greatly
appreciated.
>
cheers, Sharon.
>
>