help with ConnectionString

Question

0.00/5 (No votes)

See more:

I create small database and I want to show all information about the students that user
enter his Students ID I know that has some misktake but hope someone ill get help me to get trough this as its my fist project

I caret my database using visual studio 2008

screenshot

I think there is mistake at this statement

VB

cnn.ConnectionString = "Provider=localhost;data source=C:\USERS\USER\DOCUMENTS\VISUAL STUDIO 2008\PROJECTS\APP V1.2\APP V1.2\DATABASE1.MDF"

and the other one at way of calling tried to change all (*) fields to select one column of my database but it still give all the data in my database

VB

cmd.CommandText = "select * from Table1"

VB

<pre lang="vb">Public Class Form1

    Dim cnn As OleDb.OleDbConnection

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'Database1DataSet2.Table1' table. You can move, or remove it, as needed.
        Me.Table1TableAdapter1.Fill(Me.Database1DataSet2.Table1)
        'TODO: This line of code loads data into the 'Database1DataSet1.Table1' table. You can move, or remove it, as needed.
        Me.Table1TableAdapter.Fill(Me.Database1DataSet1.Table1)
        cnn = New OleDb.OleDbConnection
        cnn.ConnectionString = "Provider=localhost;data source=C:\USERS\USER\DOCUMENTS\VISUAL STUDIO 2008\PROJECTS\APP V1.2\APP V1.2\DATABASE1.MDF"
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim cmd As OleDb.OleDbCommand

        If Not cnn.State = ConnectionState.Open Then
            cnn.Open()
        End If
        cmd.Connection = cnn
        cmd.CommandText = "select * from Table1"
        cmd.ExecuteNonQuery()

    End Sub
End Class

Posted 31-Mar-13 13:10pm

anamo

Updated 31-Mar-13 13:15pm

v2

Add a Solution

Comments

[no name] 31-Mar-13 19:54pm

"data source=C:\USERS\USER\DOCUMENTS\VISUAL STUDIO 2008\PROJECTS\APP V1.2\APP V1.2\DATABASE1.MDF" should probably be just "data source=DATABASE1" see www.connectionstrings.com
Your second statement that I guess is actually a question, it is not possible. You could not possibly change "select * from Table1" to "select column1 from table1" and get all of the data in your database unless you only had column1 in your database.

anamo 1-Apr-13 7:27am

i tired what u said I keep get error message that says http://www.4shared.com/photo/cluDBGht/ewftsefwa.html
i tries this solution but not work out
http://www.codeproject.com/Questions/464072/The-Microsoft-Jet-OLEDB-4-0-provider-is-not-regist
and for the second answer I meant I did that just to test if my query work or not and i found it not work coz of the above error

[no name] 1-Apr-13 8:48am

"http://www.4shared.com/photo/cluDBGht/ewftsefwa.html" is not an error message. And course is does not work if you cannot connect to your database. Until you describe the real problem I am afraid that you will not get much help/

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)

anandkumarrs6 · Answer 1 · 2013-03-31T18:22:00

You can use the code bellow to populate the data grid

VB

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim constr as new OleDb.OleDbConnection
constr.ConnectionString = "Provider=localhost;data source=C:\USERS\USER\DOCUMENTS\VISUAL STUDIO 2008\PROJECTS\APP V1.2\APP V1.2\DATABASE1.MDF"
Dim sqlstr as string=""
sqlstr="select * from Table1 where StudentID=" & Textbox1.text

       Try
            Dim ds As New DataSet
            Dim apt As New SqlDataAdapter
            apt.Dispose()
            ds.Dispose()
            apt = New SqlDataAdapter(sqlstr, constr)
            apt.Fill(ds)
            Datagridview1.DataSource = ds.Tables(0)
        Catch ex As Exception
            MsgBox(ex.Message.ToString)
        End Try 
End Sub