[2008] Few Basic Questions

[jmcilhinney]

Which database you're using is pretty much irrelevant. ADO.NET code all follows the same pattern. If you're using a different database then you simply change the connection string and, perhaps, the data namespace. Follow the Data Access link in my signature for some ADO.NET code examples. As that thread says, if you're using Access you can just change SqlClient to OleDb. If you're using SQL Server CE then you just switch SqlClient to SqlServerCe.

[Tenedy]

I seem to run into trouble at this line:

Dim connection As New System.Data.SqlServerCe.SqlCeConnection("Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=C:\Users\Blake\Documents\Visual Studio 2008\Projects\Ori\Ori\Database1.sdf")

Code as a whole:

Dim connection As New System.Data.SqlServerCe.SqlCeConnection("Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=C:\Users\Blake\Documents\Visual Studio 2008\Projects\Ori\Ori\Database1.sdf")
        Dim command As New System.Data.SqlServerCe.SqlCeCommand("SELECT Price, Quest Item, Name FROM Items", connection)
        connection.Open()
        Dim reader As System.Data.SqlServerCe.SqlCeDataReader = command.ExecuteReader()
        While reader.Read()
            MessageBox.Show(String.Format("There are {0} {1} of {2} remaining in stock.", _
                                  reader("Quantity"), _
                                  reader("Unit"), _
                                  reader("Name")))
        End While
        reader.Close()
        connection.Close()