how i insert a value from textbox to database

Question

1.00/5 (2 votes)

See more:

any one can help me out from this logic error

this code can't show the data in the output

dbp = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Administrator\Documents\mydata.mdb;User Id=admin;Password=;"
        con.ConnectionString = dbp
        con.Open()


        sql = "select * from test";
        
        da = New OleDb.OleDbDataAdapter(sql, con)
        da.Fill(ds, "mydata")
        MsgBox("Database is now Open")

        con.Close()
        MsgBox("Database is Now Closed")

[Edited]code is wrapped in "pre" tags[/Edited]

Posted 23-Dec-10 19:04pm

Mudasar Ahmad

Updated 29-Dec-10 3:37am

Hiren solanki

v3

Add a Solution

Comments

Dr.Walt Fair, PE 24-Dec-10 1:27am

I see no output, other than the MsgBox's. Is it a problem with the connection or the query or something else?

Tarun.K.S 24-Dec-10 1:27am

Where do you want the output? You are just filling the dataset.

yaprig 24-Dec-10 2:25am

Do you want to insert value from textbox to database or from database to textbox??

2 solutions

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)

Hiren solanki · Accepted Answer · 2010-12-23T20:31:00

I can't see error in that code but I can see some bad practice.

I mean.

If you're using DataAdapter then no need to close connection, DataAdapter will be fully responsible for that.

Data Will be filled when you are calling da.Fill(ds,"mydata");
After that Database connection will be closed. and you stated that "Database is now open" and Further you closed again connection which is already closed.

For safe side to close connection you should use.

if (con.State == ConnectionState.Open)
 con.close();

Sandeep Mewara · Accepted Answer · 2010-12-23T20:50:00

Well, the above code just brings data from database and fills it in a dataset. Nothing else. You put a messagebox to display some message. There is no code written to display the data fetched.

As correctly said, it's a logical error in understanding. If you need to see the data fetched then for sample, place a grid on the page and then bind the dataset fetched to this grid. Data retrieved would be visible in this grid.

how i insert a value from textbox to database

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0