asp mvc uploads a record three time on one click

Question

when I click html bttn to upload a data as name phone date and time it uploads it three time. it uploaded a record 9 times instead on 1 time but since I changed some html codes it became to upload a record three times instead of 1

here is the action result on homeController

here is my html webview

and here is my table after I clicked the upload button for 3 three time only.

nwenar abbas · Answer

kapil ananth so you mean to ceate a local database or what i didnt get you

Kapil Aananth · Answer

Instead of directly updating a values in database use Models to insert data. and check whether the data while passing to contoller is not redundant public class Datas(){ public string Name{get; set} public string Phone{get; set} public string Date{get; set} public string Time{get; set} } public ActionResult GetInQueues (){ Datas data = new Datas(); data.Name = Request["Mame"] data.Phone = Request["phone "] data.Date = Request["date"] data.Time =Request["Time"] insertdata(data) } public void insertdata(Datas data){ sqlconnection con = new sqlconnection("") //DB connections using( sqlCommand cmd = new sqlCommand ("insert into Queue(Name,Phone,Date,Time) values('"+data.Name+"','"+data.Phone+"','"+data.Date+"','"+data.Time+"')",con)) { con.open(); cmd.ExecuteNonQuery(); }

asp mvc uploads a record three time on one click

Answers (2)