asp mvc uploads a record three time on one click

nwenar abbas

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.

2 Replies

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

nwenar abbas4y ago
kapil ananth so you mean to ceate a local database or what i didnt get you
0
Kapil Aananth4y ago
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();
}
0