Ms Access Insert Problem

Question

0.00/5 (No votes)

See more:

Dear All I m Using Window forms using c# server side code .

using access database . i add app config file in this app config i cretae this connection

XML

<add name="ROMS.Properties.Settings.DBRomsConnectionString" connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Resources\DBRoms.mdb;Persist Security Info=True" providerName="System.Data.OleDb" />

Than i call this directly form.cs file

C#

OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\USER\Desktop\ROMS\ROMS\ROMS\Resources\DBRoms.mdb");

i donot know how to call this connection string .

i get problem to insert point : -

C#

query = "INSERT INTO Employee(EmployeeID,LoginID,Department,Designation,FinYear1,FinYear2,Password,) VALUES('" + txtEmployeeId.Text + "','" + txtLoginId.Text + "','" + CBEmployeeDepartment.SelectedItem.ToString() + "','" + CBEmployeeDesignation.SelectedItem.ToString() + "','" + CBFinYear1.SelectedItem.ToString() + "','" + CBFinYear2.SelectedItem.ToString() + "','" + txtEmployeePassword.Text + "')";
con.Open();
cmd = new OleDbCommand(query, con);
cmd.ExecuteNonQuery();
con.Close();

I get error in Execute nonquery .

all data field value is text .

Posted 27-Jan-14 20:27pm

Rohit85

Updated 27-Jan-14 20:48pm

phil.o

v4

Add a Solution

Comments

karthik Udhayakumar 28-Jan-14 2:30am

Hello Rohit,

Are you using window forms or webforms?pls be clear in writing the questions to help you
!

Rohit85 28-Jan-14 2:31am

Window Forms .

karthik Udhayakumar 28-Jan-14 2:34am

Pls Correct your question first ,change the heading as MsAccess connection issue or something like that and remove the place where you have mentioned as webform to winform ..And add the code were you are facing the issue..Then let us check how to resolve!

Rohit85 28-Jan-14 2:39am

how will i edit question ? i did not get option

phil.o 28-Jan-14 2:46am

Click on the 'Improve question' button at its bottom.

Rohit85 28-Jan-14 3:14am

Tell me hot to call connection string in form1.cs file

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)

thatraja · Accepted Answer · 2014-01-27T21:02:00

Solution 1

Remove the last comma from INSERT query

query = "INSERT INTO Employee(EmployeeID,LoginID,Department,Designation,FinYear1,FinYear2,Password,) VALUES('" +

EDIT

Don't use keywords/reserved words like Password. You have to add square brackets for that column like below but I wont recommend that. You should rename the column name( like Emp_Password )

[Password]

Posted 27-Jan-14 21:02pm

thatraja

Updated 27-Jan-14 22:36pm

v4

Comments

Rohit85 28-Jan-14 4:10am

dear it show Errot Syntax error in INSERT INTO statement.

thatraja 28-Jan-14 4:15am

Ofcourse, the problem is in your query(unwanted comma at end). Did you read my answer fully?

Rohit85 28-Jan-14 4:26am

I remove this comms than after it show this error

thatraja 28-Jan-14 4:36am

Check updated answer

Rohit85 28-Jan-14 4:38am

OK I Use this

Rohit85 28-Jan-14 4:46am

Successfully Run this . Dear nut Tell me one thing If i use connection string in App config than how we call this connectionstring in form1.cs page

thatraja 28-Jan-14 5:05am

nut?

And for next question, you should have used Google. Check this Tip/Trick
How to get Connection String from App.Config in C#

karthik Udhayakumar 28-Jan-14 5:21am

:)