Inserting datas from C# to Access

Question

0.00/5 (No votes)

See more:

Hi,
How to insert a data from C# to Access.I'm using access 2007.
I have tried the following codebut it is not working,

C#

con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.12.0;Data Source=D:\\weightbridge.mdb;Persist Security Info=False");
            con.Open();
            cmd = new OleDbCommand("Insert into SupplierMaster Values('"+comboBox1.SelectedItem+"','"+textBox1.Text+"')", con);
            cmd.ExecuteNonQuery();
            con.Close();
            MessageBox.Show("Request Sent Successfully");

Regards
Balamurugan

Posted 3-Jan-13 17:47pm

Balamurugan1989

Updated 3-Jan-13 17:50pm

Sandeep Mewara

v2

Add a Solution

Comments

Sandeep Mewara 3-Jan-13 23:51pm

Elaborate 'not working'. Is there any error? What do you see when you DEBUG?

Balamurugan1989 4-Jan-13 0:09am

I have used the below code i'm not getting error in coding but it s not saving in access.

string nam;
WeightBridge.Class1 obj = new WeightBridge.Class1();
nam = obj.get();
OleDbConnection con = new OleDbConnection(nam);
con.Open();
OleDbCommand cmd = new OleDbCommand("INSERT INTO SupplierMaster VALUES('" +comboBox1.SelectedItem + "','" + textBox1.Text + "')", con);
cmd.ExecuteNonQuery();
MessageBox.Show("Supplier Master Details Saved Successfully");

3 solutions

Solution 1

This code is horrible. Read up on SQL Injection to see how I can use your form to erase your database. Either way, you need to tell us the error message if you want us to help you. Your code looks fine, assuming the table only has two fields that can be inserted. I'd add the SQL to list what columns you want to insert in to, and then if that does not help, read the error message ( we are going to tell you that it means what it says ) and post it here if you still don't get it ( edit your post )

Posted 3-Jan-13 17:52pm

Christian Graus

Comments

Balamurugan1989 4-Jan-13 0:09am

I have used the below code i'm not getting error in coding but it s not saving in access.

string nam;
WeightBridge.Class1 obj = new WeightBridge.Class1();
nam = obj.get();
OleDbConnection con = new OleDbConnection(nam);
con.Open();
OleDbCommand cmd = new OleDbCommand("INSERT INTO SupplierMaster VALUES('" +comboBox1.SelectedItem + "','" + textBox1.Text + "')", con);
cmd.ExecuteNonQuery();
MessageBox.Show("Supplier Master Details Saved Successfully");

Christian Graus 4-Jan-13 0:29am

You gave me a two vote, but didn't bother to do anything I suggested ? What is the format of the table ?

Solution 3

if (dr != null && dr.HasRows)
{
//dbReader.Read() will return true until there are no more rows to be read
while (dr.Read())
{
listBox1.Items.Add(dr["SupCode"]);
}
}

Posted 4-Jan-13 23:54pm

Balamurugan1989

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)

Balamurugan1989 · Accepted Answer · 2013-01-03T21:53:00

private void button5_Click(object sender, EventArgs e)
{
string nam;
WeightBridge.Class1 obj = new WeightBridge.Class1();
nam = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\\weightbridge.accdb;Persist Security Info=False;";
OleDbConnection con = new OleDbConnection(nam);
con.Open();
OleDbCommand cmd = new OleDbCommand("INSERT INTO SupplierMaster VALUES('" + textBox2.Text + "','" + textBox1.Text + "')", con);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("SupplierMaster Saved Successfully");

}