Access C# Data Insert Problem

Burak Seyhan

9y1.1kLearn iOS Programming

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

4 Replies

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

Satyaprakash Samantaray9y ago
check my article and blog , u will get the result
0
Rajkiran Swain9y ago
Put brackets [] around the table name "User". It's a reserved word .
0

Sundaram Subramanian9y ago

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

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

Manikandan Murugesan9y ago
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
0