Database

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

BobClarkSQL wrote:

The Customer Specified and Suggested this configuration. I do not have to do it that way as long as is completely free and NoLicenses are requires

fifothekid wrote:

the only thing that I want to implement is that to make my program read only the record that I'm viewing currently on the form

using (SqlConnection connection = new SqlConnection(connectionString)) {
   SqlCommand command = new SqlCommand("SELECT * Customer WHERE ID = @Id", connection);
   command.Parameters.AddWithValue("@ID", 5);
   connection.Open();
   SqlDataReader reader = command.ExecuteReader();
   reader.Read(); 
   ...

fifothekid wrote:

using the SqlCommand while limiting the number of records is not the thing that I want, for example, if I use it to read 10 rows only, then only those rows will be displayed in the form, and this is not correct in my case

update yourtablename
set Result = col1 + col2