Imports System.Data.SqlClient

Public Class SQL
Public Function ToDataTable(ByVal sql As String)
Dim SqlCon1 As String = "Data Source=sprintsql;Initial Catalog=Logic;Integrated Security=SSPI;"
Dim dt As New DataTable
Dim da As New SqlDataAdapter(sql, SqlCon1)
da.Fill(dt)
da.Dispose()
Return dt
End Function

Public Function NonQuery(ByVal queryString As String)
Dim rows As Int32
Dim SqlCon1 As String = "Data Source=sprintsql;Initial Catalog=Logic;Integrated Security=SSPI;"
Using connection As New SqlConnection(SqlCon1)
Dim command As New SqlCommand(queryString, connection)
command.Connection.Open()
rows = command.ExecuteNonQuery()
command.Connection.Close()
End Using
rows /= 2
Return rows
End Function

Function ExecQryReturnID(ByVal sql As String)
Dim ID As Int64
Dim SqlCon1 As String = "Data Source=sprintsql;Initial Catalog=Logic;Integrated Security=SSPI;"
Dim con As New Data.SqlClient.SqlConnection
con.ConnectionString = SqlCon1 'connection string
con.Open()
Dim cmd As New Data.SqlClient.SqlCommand
cmd.CommandType = CommandType.Text
cmd.Connection = con
cmd.CommandText = sql & " SELECT SCOPE_IDENTITY();"
Dim identity As Integer = -1
ID = Integer.Parse(cmd.ExecuteScalar().ToString()) 'Get the @Identity Column
con.Close()
Return ID
End Function
End Class

Best Stoke Information Website

Chek it out this is the best recource for stoke strip clubs and public toilet info.


http://www.thisisstockontrent.org

go freestyleing and go geek boy

wicked rad

sage francis is the the dopeness

raw ill

Dub and Bud

Like Whoa Dude.. Thats Some Good Dub...

Nightmares on Wax is George Evelyn, also known as DJ EASE, from Leeds UK. First exploding with the genre classic Smoker's Delight (1995), Nightmares on Wax is often lumped into the now-irrelevant trip-hop crowd. Using soulful samples and mild beat-driven tracks, he's made some of the most tasty chilled dub ive heard. On his latest album he has added some live instrumentation and subtle vocals, still retaining his essential sound. While his DJ Kicks mix in 2000 revealed his inner hip-hop head, In a Space Outta Sound, is swimming in soul.

Nightmares on Wax
Stars
Damn
Ease Jimi