Database

InstructionsNote: You must have administrative rights on the computer to install SQL Server Express.
We recommended that you read the Release Notes and Readme before installing SQL Server Express with Advance Services.
Step 1: Download and install Microsoft .Net Framework 3.5 SP1. 
Step 2: Download and install Windows Installer 4.5.
Step 3: Download and install Windows PowerShell 1.0. ...

Unsy wrote:

it tells me it cant start up a user instance

Unsy wrote:

, I think it would be better to ship all my .MDF files into real sql server which would be better anyway, but I cant find how to do this...

Dim queryString As String = "SELECT * FROM dbo.ADR_BASE;"

Using connection As New SqlConnection("Data Source=DEVBOX;Initial Catalog=PermitsPlus;Persist Security Info=True;User ID=*****;Password=*****")

    Dim command As New SqlCommand(queryString, connection)
    connection.Open()

    Dim reader As SqlDataReader = command.ExecuteReader()

    DataGridView1.DataSource = PermitsPlusDataSet.ADR_BASE.Load(reader)

Dim queryString As String = "SELECT * FROM dbo.ADR_BASE;"
Using connection As New SqlConnection("Data Source=DEVBOX;Initial Catalog=PermitsPlus;Persist Security Info=True;User ID=*****;Password=*****")
   Dim command As New SqlCommand(queryString, connection)
   connection.Open()
   Dim reader As SqlDataReader = command.ExecuteReader()
   Dim tempTable As new System.Data.DataTable("ADR_BASE")
   tempTable.Load(reader)
   DataGridView1.DataSource = tempTable
   'PermitsPlusDataSet.ADR_BASE.Load(reader)
   'DataGridView1.DataSource = PermitsPlusDataSet.ADR_BASE.Load(reader)

enipla wrote:

if I pan across the different columns, I get an error "System.ArgumentException: Parameter not valid. Apparently I have a datatype it doesn't like.

enipla wrote:

I really want to thank you for you quick responses