Access C# Data Insert Problem

Question

string SqlString = "Insert Into tb_Users (UserName, Password,IsDeleted) Values (?,?,?)";

using (OleDbCommand cmd = new OleDbCommand(SqlString, myCon))

{

cmd.CommandType = CommandType.Text;

cmd.Parameters.AddWithValue("UserName", "asd");

cmd.Parameters.AddWithValue("Password", "asdsadasdas");

cmd.Parameters.AddWithValue("IsDeleted", "fff");

myCon.Open();

cmd.ExecuteNonQuery();

}

 

Why this code doesn't work ? Always insert code return Syntax error in INSERT INTO statement. message. where is the problem please help me 

Answer 1

check my article and blog , u will get the result

Answer 2

Put brackets [] around the table name "User". It's a reserved word .

Answer 3

1) http://csharp.net-informations.com/dataadapter/insertcommand-oledb.htm

 

2)

 

using(OleDbConnection myCon = new OleDbConnection(ConfigurationManager.ConnectionStrings["DbConn"].ToString())) { OleDbCommand cmd = new OleDbCommand();     cmd.CommandType = CommandType.Text;     cmd.CommandText = "insert into Items ([Item_Name],[Item_Price]) values (?,?);    cmd.Parameters.AddWithValue("@item", itemNameTBox.Text);    cmd.Parameters.AddWithValue("@price", Convert.ToDouble(itemPriceTBox.Text));     cmd.Connection = myCon;     myCon.Open();     cmd.ExecuteNonQuery(); System.Windows.Forms.MessageBox.Show("An Item has been successfully added", "Caption", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); }

hope this will help. Thanks in advance 

Answer 4

Refer this link : https://stackoverflow.com/questions/30112697/c-sharp-insert-into-access-database-no-error-command-succeeds-but-no-data-ins

 

https://forums.asp.net/t/1186309.aspx?c+access+database+insert+problem