sqlCommand = "INSERT INTO " + tableName + " ( usernameFname, upasswordLname, genderGender, FavNum, FavTeam, UID) "; ▼ויקסי שחיף
sqlCommand += "VALUES ('" + fnameFname + "','" + lnameLname + "','" + uemailGender + "','" + upasswordFavNum + "','" + genderFavTeam + "','" + age + "', '" + uidUID + "')"; ▼
string sqlCommand = "";
string fileName = "database.accdb";
string tableName = "table1";
string name = Request["username"];
string gender = Request["gender"];
string password = Request["password"];
▲ sqlCommand = "INSERT INTO " + tableName + " (username, upassword, gender) ";
sqlCommand += " VALUES ('" + name + "', '" + password + "', '" + gender + "')";
//Response.Write(sqlCommand);
//Response.End();
MyAdoHelper.DoQuery(fileName, sqlCommand);
▲ sqlCommand += "VALUES ('" + fname + "','" + lname + "','" + uemail + "','" + upassword + "','" + gender + "','" + age + "', '" + uid + "')";
|
