inserting records form asp.net page

Question

1.00/5 (1 vote)

See more:

how to access the values from a text box in an asp.net web form and save it back to an database in MS access. Im new to asp.net. So please explain suitably. Thanks in advance

Posted 21-Sep-12 4:16am

Sriram Mani

Add a Solution

Comments

[no name] 21-Sep-12 10:20am

What have you tried?

Sriram Mani 21-Sep-12 23:56pm

thanks for the reply wes..
im using c# language. so far i used grid view for displaying data from a ms access database and it works fine. now i created a simple web form in asp.net where in the user gives form input. that input should be inserted into a table in that database. i have no idea what to use.... i'm using visual studio 2008 ..

joshrduncan2012 21-Sep-12 10:22am

What language are you using? What have you tried so far? What errors are you receiving? What does your output look like? Can you post a portion of your code so we can find where the problem is?

Sriram Mani 21-Sep-12 23:55pm

thanks for the reply josh,
im using c# language. so far i used grid view for displaying data from a ms access database and it works fine. now i created a simple web form in asp.net where in the user gives form input. that input should be inserted into a table in that database. i have no idea what to use.... i'm using visual studio 2008 ..

fjdiewornncalwe 21-Sep-12 10:22am

Wes has provided the polite comment that is suitable. I'll expand on that.
There is a wonderful tool out there called GOOGLE. Think of him as your best friend who is actually really, really smart and has a photographic memory. Ask him the question first because you'll be surprised how often he has the answers right there. It's like a drive through fast food place. It's quick and it's convenient, but none of the usless calories. Cheers.

Sriram Mani 21-Sep-12 23:59pm

i googled it a lot.. i got many answers.. but most of it are in vb rather than c#. i got some results in c# too.. but they're given for normal application of c# but not to asp.net page.

fjdiewornncalwe 22-Sep-12 15:31pm

There is really no difference on the back end with inserting records and reading from a database. The only difference between asp.net and a winforms app is now that data is presented to a user.

Sriram Mani 23-Sep-12 9:30am

Marcus, i used grid view for viewing the data from database. but im not sure whether i can do the same for inserting back in a database.

fjdiewornncalwe 23-Sep-12 11:13am

UI objects have NOTHING to do with inserting data into a database. That is ALWAYS handled by code behind. The UI is simply a mechanism for interacting between your code behind and the user. The code behind is what communicates and interacts with the database.

Sriram Mani 24-Sep-12 1:40am

Thanks for the reply Marcus, and that's what i'm asking for... i need the code in c# for getting the input data from the form and save those in a table inside a MS access database.

2 solutions

Solution 1

Okay, there are two major things involved in it: Connection String formation & How to talk to DB & save data.

Following material would help you out:
For connection string: Connection String[^]!

For data communication:
Accessing data with ADO.NET[^]
Beginners guide to accessing SQL Server through C#[^]

Try!

Posted 21-Sep-12 4:45am

Sandeep Mewara

Comments

Sriram Mani 22-Sep-12 0:04am

thanks for the reply sandeep, ill surely go through these... thanks a lot...

Sandeep Mewara 22-Sep-12 1:20am

Welcome.

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)

Sriram Mani · Accepted Answer · 2012-09-24T02:14:00

Thanks for all who spared their precious time in answering me. I finally had it working and it was very simple. At first d textboxes are not known inside the c# code. i right clicked each text box and clicked view code which opens the c# code page. there i used d syntax

C#

txtboxname.Text;

stmt to retrive it and used the query "Insert into tablename values ('"+txtboxname.Text+"'....);" to accomplish the insertion.. and it worked fine.