c# with ms access database urgent

mind controll

i want to save data from :
idbox (textbox) - empbox (combobox) - unitbox (combobox) - destbox (combobox) -
detectivebox (combobox) - statebox (combobox) - investdate (datepicker) -
investresult (textbox)
into the table investinside same order
id - emp - unit - dest - detective - state - investdate - investresult
i tried this one but didn't work plz help

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OleDb;
namespace beta_2
{
public partial class Dentry_main : Form
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=beta 2.mdb;");
OleDbDataAdapter da;
DataSet ds = new DataSet();
OleDbCommand com=new OleDbCommand();
string sql;

public Dentry_main()
{
InitializeComponent();
}
private void Dentry_main_Load(object sender, EventArgs e)
{

}
private void button1_Click(object sender, EventArgs e)
{
conn.Open();
com.Connection = conn;
sql = "INSERT INTO investinside([id],[emp],[unit],[dest],[detective],[state],[investdate],[investresult])VALUES(?,?,?,?,?,?,?,?)";
com.CommandText = sql;
com.Parameters.Clear();
com.Parameters.AddWithValue("id", idbox.Text);
com.Parameters.AddWithValue("emp", empbox.Text);
com.Parameters.AddWithValue("unit", unitbox.Text);
com.Parameters.AddWithValue("dest", destbox.Text);
com.Parameters.AddWithValue("detective", detectivebox.Text);
com.Parameters.AddWithValue("state", statebox.Text);
com.Parameters.AddWithValue("investdate", investdatebox.Text);
com.Parameters.AddWithValue("investresult", investresultbox.Text);
com.ExecuteNonQuery();
MessageBox.Show("success");
conn.Close();

}
}
}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pradip Pandey13y ago
Please check the length of your string i.e. value for the fields like emp, unit, dest, detective, state, investdate and investresult passing from the UI. Also check the data type of the fields whether they are similar with the values passing from the UI.

Hope it will help.
0
mind controll13y ago
i made some modifications but this time no error but the data never saved when i check the data file

here's after modifications

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OleDb;

namespace beta_2
{
    public partial class Dentry_main : Form
    {
        OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=beta2.mdb;");
        OleDbDataAdapter da;
        DataSet ds = new DataSet();
        OleDbCommand com = new OleDbCommand();
        string sql;
        public Dentry_main()
        {
            InitializeComponent();
        }
        private void Dentry_main_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'beta2DataSet.stateinside' table. You can move, or remove it, as needed.
            this.stateinsideTableAdapter.Fill(this.beta2DataSet.stateinside);
            // TODO: This line of code loads data into the 'beta2DataSet.detectivestbl' table. You can move, or remove it, as needed.
            this.detectivestblTableAdapter.Fill(this.beta2DataSet.detectivestbl);
            // TODO: This line of code loads data into the 'beta2DataSet.departments' table. You can move, or remove it, as needed.
            this.departmentsTableAdapter.Fill(this.beta2DataSet.departments);
            // TODO: This line of code loads data into the 'beta2DataSet.units' table. You can move, or remove it, as needed.
            this.unitsTableAdapter.Fill(this.beta2DataSet.units);
            // TODO: This line of code loads data into the 'beta2DataSet.employees' table. You can move, or remove it, as needed.
            this.employeesTableAdapter.Fill(this.beta2DataSet.employees);
        }
        private void button1_Click(object sender, EventArgs e)
        {
            conn.Open();
            com.Connection = conn;
            sql = "INSERT INTO investinside([id],[emp],[job],[unit],[dest],[detective],[state],[investdate],[investresult])VALUES(@id,@emp,@job,@unit,@dest,@detective,@state,@investdate,@investresult)";
            com.CommandText = sql;
            com.Parameters.Clear();
            com.Parameters.AddWithValue("@id", idbox.Text);
            com.Parameters.AddWithValue("@emp", empbox.Text);
            com.Parameters.AddWithValue("@job", jobbox.Text);
            com.Parameters.AddWithValue("@unit", unitbox.Text);
            com.Parameters.AddWithValue("@dest", destbox.Text);
            com.Parameters.AddWithValue("@detective", detectivebox.Text);
            com.Parameters.AddWithValue("@state", statebox.Text);
            com.Parameters.AddWithValue("@investdate", investdatebox.Text);
            com.Parameters.AddWithValue("@investresult", investresultbox.Text);
            com.ExecuteNonQuery();
            MessageBox.Show("success");
            conn.Close();
        }
    }
}
0
mind controll13y ago
i made some changes but now i don't get any errors but when i open the database i find the data wasn't saved as if it made no effect

this is after modifications

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OleDb;

namespace beta_2
{
    public partial class Dentry_main : Form
    {
        OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=beta2.mdb;");
        OleDbDataAdapter da;
        DataSet ds = new DataSet();
        OleDbCommand com = new OleDbCommand();
        string sql;
        public Dentry_main()
        {
            InitializeComponent();
        }
        private void Dentry_main_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'beta2DataSet.stateinside' table. You can move, or remove it, as needed.
            this.stateinsideTableAdapter.Fill(this.beta2DataSet.stateinside);
            // TODO: This line of code loads data into the 'beta2DataSet.detectivestbl' table. You can move, or remove it, as needed.
            this.detectivestblTableAdapter.Fill(this.beta2DataSet.detectivestbl);
            // TODO: This line of code loads data into the 'beta2DataSet.departments' table. You can move, or remove it, as needed.
            this.departmentsTableAdapter.Fill(this.beta2DataSet.departments);
            // TODO: This line of code loads data into the 'beta2DataSet.units' table. You can move, or remove it, as needed.
            this.unitsTableAdapter.Fill(this.beta2DataSet.units);
            // TODO: This line of code loads data into the 'beta2DataSet.employees' table. You can move, or remove it, as needed.
            this.employeesTableAdapter.Fill(this.beta2DataSet.employees);
        }
        private void button1_Click(object sender, EventArgs e)
        {
            conn.Open();
            com.Connection = conn;
            sql = "INSERT INTO investinside([id],[emp],[job],[unit],[dest],[detective],[state],[investdate],[investresult])VALUES(@id,@emp,@job,@unit,@dest,@detective,@state,@investdate,@investresult)";
            com.CommandText = sql;
            com.Parameters.Clear();
            com.Parameters.AddWithValue("@id", idbox.Text);
            com.Parameters.AddWithValue("@emp", empbox.Text);
            com.Parameters.AddWithValue("@job", jobbox.Text);
            com.Parameters.AddWithValue("@unit", unitbox.Text);
            com.Parameters.AddWithValue("@dest", destbox.Text);
            com.Parameters.AddWithValue("@detective", detectivebox.Text);
            com.Parameters.AddWithValue("@state", statebox.Text);
            com.Parameters.AddWithValue("@investdate", investdatebox.Text);
            com.Parameters.AddWithValue("@investresult", investresultbox.Text);
            com.ExecuteNonQuery();
            MessageBox.Show("success");
            conn.Close();
        }
    }
}
0
Satyapriya Nayak13y ago
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace Registration_in_Msaccess
{
    public partial class Form2 : Form
    {
        string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"];
        OleDbCommand com=new OleDbCommand();
        string sql;

        public Form2()
        {
            InitializeComponent();
        }

        private void btn_insert_Click(object sender, EventArgs e)
        {
            OleDbConnection con = new OleDbConnection(ConnectionString);
            con.Open();
            sql = "INSERT INTO investinside([id],[emp],[unit],[dest],[detective],[state],[investdate],[investresult])VALUES(?,?,?,?,?,?,?,?)";
            com.Connection = con;
            com.CommandText = sql;
            com.Parameters.Clear();
            com.Parameters.AddWithValue("id", idbox.Text);
            com.Parameters.AddWithValue("emp", empbox.Text);
            com.Parameters.AddWithValue("unit", unitbox.Text);
            com.Parameters.AddWithValue("dest", destbox.Text);
            com.Parameters.AddWithValue("detective", detectivebox.Text);
            com.Parameters.AddWithValue("state", statebox.Text);
            com.Parameters.AddWithValue("investdate", investdatebox.Text);
            com.Parameters.AddWithValue("investresult", investresultbox.Text);
            com.ExecuteNonQuery();
            MessageBox.Show("success");
            con.Close();
        }

        private void Form2_Load(object sender, EventArgs e)
        {
            empbox.Items.Add("e001");
            empbox.Items.Add("e002");

            unitbox.Items.Add("1");
            unitbox.Items.Add("2");

            destbox.Items.Add("manager");
            destbox.Items.Add("producer");

            detectivebox.Items.Add("a");
            detectivebox.Items.Add("b");

            statebox.Items.Add("d");
            statebox.Items.Add("e");

        }
    }
}
0
Jignesh Trivedi13y ago
hi,
Try following code, might it work for you.
in this code just i replace "?" to real parameter name. and also add "@" before parameter name.

sql = "INSERT INTO investinside([id],[emp],[unit],[dest],[detective],[state],[investdate],[investresult])VALUES(@id,@emp,@unit,@dest,@detective,@state,@investdate,@investresult)";
com.CommandText = sql;
com.Parameters.Clear();
com.Parameters.AddWithValue("@id", idbox.Text);
com.Parameters.AddWithValue("@emp", empbox.Text);
com.Parameters.AddWithValue("@unit", unitbox.Text);
com.Parameters.AddWithValue("@dest", destbox.Text);
com.Parameters.AddWithValue("@detective", detectivebox.Text);
com.Parameters.AddWithValue("@state", statebox.Text);
com.Parameters.AddWithValue("@investdate", investdatebox.Text);
com.Parameters.AddWithValue("@investresult", investresultbox.Text);
hope this will help you.
0