Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

?
Lv 6

I have a problem when using an INSERT statement, ASP.NET?

I'm using C# and Access database. I've written the INSERT statement several times, but this time it is not working. I don't know why

Here's some of the code:

con.Open();

OleDbCommand cmd = new OleDbCommand();

cmd.Connection = con;

cmd.CommandType = CommandType.Text;

cmd.CommandText = string.Format("INSERT INTO Customers (Username, Password, fName, lName, Account, PhoneNumber, Email) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", usertbx.Text, Passwordtbx.Text, fntbx.Text, lntbx.Text, accounttbx.Text, phtbx.Text, emailtbx.Text);

int rows = cmd.ExecuteNonQuery();

1 Answer

Relevance
  • Anonymous
    9 years ago
    Favorite Answer

    This must be the programming problem.

    Report this problem to the programming service to get it fixed.

Still have questions? Get your answers by asking now.