can someone help me with creating a sdf viewer application

Question

1.00/5 (3 votes)

See more:

i believe that this code views the data in the sdf file in a datagrid.

VB

Imports System.Data.SqlServerCe
Public Class Form1

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim scon As SqlCeConnection = New SqlCeConnection("Data Source=C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Samples\Northwind.sdf")

        Dim ceda As SqlCeDataAdapter = New SqlCeDataAdapter("Select * from Suppliers", scon)

        Dim ds As New DataSet

        ceda.Fill(ds, "MyTable")

        DataGridView1.DataSource = ds.Tables("MyTable").DefaultView

        ' Also you can iterate data from datatable like this:

        'ds.Tables("MyTable").Rows(rowIndex).Item(colIndex).ToString()
    End Sub
End Class

but i need to make an application that opens the sdf file without putting the sdf file in the source code in vb.net
what i mean is when you want to add a database file in your program you add it as an existing item.
what i want is the user can search for the sdf file in his/her directories and the application shows the data in the database.

but i dont know where to start. guys do you have any idea about this?
i want to achieve something like this http://sdf-viewer.software.informer.com/[^]

Posted 23-Apr-13 15:10pm

Member 9993496

Updated 5-Jul-21 5:27am

v3

Add a Solution

Comments

TnTinMn 23-Apr-13 21:53pm

What has you done so far? No one is going to write this application for you.

Here is a hint: First retrieve a table of Tables in the DB. This is accessed using "SELECT * FROM INFORMATION_SCHEMA.TABLES". Then you can retrieve each Table in the DB and display it's contents.

[no name] 23-Apr-13 22:18pm

i am currently working on it. thanks for the suggestion.

[no name] 23-Apr-13 22:14pm

Okay so what is wrong with the open file dialog?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2013-04-23T19:03:00

Wow. This is going to go well.

We already told you about the OpenFileDialog and you still don't know anything about it. This tells us that you're pretty much going to ignore anything we tell you, not teach yourself anything, and anyone but you is going to end up writing the vast majority of this app.

You can't write this app from a bunch of forum posts. You've got no experience to tell you how to design the app (you're NOT going to learn that in forums either!) and don't have a clue about all of the little bits you're going to need to put this together.

For example... Do you know how to get all of the tables in a database using and SQL SELECT statement? How about the columns of a table? Their definitions? Indexes? Key information?

How about how you're going to disaply all of this information? Do you know how you're going to layout your forms? What controls you're going to need? How about maintaining the application and visual state information?

...and that's only what my groggy little brain came up with in about 5 seconds of thinking about that app.