I have a table "BetPosition" where "BetNo" is auto incremented.
I intend to insert records through user interface where information for "odds1", "odds2"..etc comes from text boxes.
I do not know how to write the statement where text boxes values gets updated to the database.
I wrote:
Sql1.ExecNonQuery ("Insert into BetPosition (Odds1, Odds2, Favourite, Amount, BetTeam) values (EditText2.Text, EditText7.Text, EditText6.Text, EditText9.Text, EditText8.Text) ")
which is not working.
Please help with the correct syntax.
Thanks in advance.
I intend to insert records through user interface where information for "odds1", "odds2"..etc comes from text boxes.
I do not know how to write the statement where text boxes values gets updated to the database.
I wrote:
Sql1.ExecNonQuery ("Insert into BetPosition (Odds1, Odds2, Favourite, Amount, BetTeam) values (EditText2.Text, EditText7.Text, EditText6.Text, EditText9.Text, EditText8.Text) ")
which is not working.
Please help with the correct syntax.
Thanks in advance.