doesnt save...

Mfwamba Tshimanga

12y1.4kLearn iOS Programming

Hi!

Please could you see these codes. Its doesnt save on my database. I am not what happen.

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 LunaOffice

{

public partial class RegistrarDemissao : Form

{

public Saveagent()

{

InitializeComponent();

}

OleDbConnection conn;

OleDbCommand comm;

string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\office\office\\app_data\office.mdb;Persist Security Info=False";

private void btnSaveCompany_Click(object sender, EventArgs e)

{

conn = new OleDbConnection(connstr);

comm = new OleDbCommand();

conn.Open();

OleDbParameter name = new OleDbParameter("@nam", SqlDbType.VarChar);

comm.Parameters.Add(name);

funcionario.Value = cbxName.Text;

comm.Connection = conn;

comm.CommandText = "insert into Full_Company values(@nam)";

try

{

comm.ExecuteNonQuery();

MessageBox.Show("Saved...");

}

catch (Exception)

{

MessageBox.Show("Not Saved...");

}

finally

{

conn.Close();

}

8 Replies

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

Vulpes12y ago
Accepted answer
It appears from the error message that there is more than one column in the table and that the one you're inserting is not the first column.

If that's the case and the name of that column is 'name', then try replacing:

comm.CommandText = "insert into Full_Company values(@nam)";

with:

comm.CommandText = "insert into Full_Company ([name]) values(@nam)";
Mfwamba Tshimanga12y ago
yeeeeeeeeees! Its works. Thanx to all... Specially to VULPES. Thank you again to all.
Mfwamba Tshimanga12y ago
I receive this message after inserted the Vulpes code: The value number of query and the column are not the same.
Riddhi Valecha12y ago
Hi..

You are missing the lines -

comm.CommandType = CommandType.StoredProcedure;
comm.text = "Stored_Procedure_Name";
comm.parameter.Addwithvalue("@abc",'abc');
-------

You have to say whether you are using a stored procedure or simple query.

------
Wim Sturkenboom12y ago
[quote]
catch (Exception)
{
MessageBox.Show("Not Saved...");
}
[/quote]
Never hide exceptions; if you don't want the user to see them, log them to file and display the 'tailored' message. Vulpes has shown how to find the error.
Vulpes12y ago
Make the highlighted changes, so we can see what the exception is:

try
{
comm.ExecuteNonQuery();
MessageBox.Show("Saved...");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
Mfwamba Tshimanga12y ago
I do try it. But its doesnt save.
Its shown this message: Not saved... That mean its doenst save. I dont know what happen.
Vulpes12y ago
Try making these alterations:

OleDbParameter name = new OleDbParameter("@nam", OleDbType.VarChar);

comm.CommandText = "insert into Full_Company values(?)";