c# - System.Data.SqlClient.SqlException when I insert generates conflict with foreign key -

c# - System.Data.SqlClient.SqlException when I insert generates conflict with foreign key -

i have table

when seek insert new cargo appear exception saying

insert statement conflicted foreign key constraint "fk_cargo_rol". conflict has appeared in database "banco" table "dbo.rol", column 'idrol'. statement has been terminated.

this code aspx.cs

public partial class public_cargo_crearcargo : system.web.ui.page { protected void page_load(object sender, eventargs e) { if(!ispostback){ string query1 = @"select * formula"; string query2 = @"select * rol"; using (sqlconnection con = new sqlconnection(configurationmanager.connectionstrings["banco"].tostring())) { sqlcommand comand = new sqlcommand(query1, con); sqlcommand comand2 = new sqlcommand(query2, con); dataset ds = new dataset(); dataset ds2 = new dataset(); con.open(); var adapter = new sqldataadapter(comand); var adapter2 = new sqldataadapter(comand2); adapter.fill(ds, "formula"); adapter2.fill(ds2, "rol"); select1.datasource = ds; select1.datatextfield = "formula"; select1.datavaluefield = "idformula"; select1.databind(); select2.datasource = ds2; select2.datatextfield = "nombre_rol"; select2.datavaluefield = "idrol"; select2.databind(); } } } protected void docreatecargo(object sender, eventargs e) { string query = @"insert cargo (nombre, idformula, idrol) values (@nombre, @idformula, @idrol)"; using (sqlconnection con = new sqlconnection(configurationmanager.connectionstrings["banco"].tostring())) { sqlcommand comand = new sqlcommand(query, con); comand.parameters.addwithvalue("@idformula", select1.selectedindex.tostring()); comand.parameters.addwithvalue("@idrol", select2.selectedindex.tostring()); comand.parameters.addwithvalue("@nombre", cargo.text); con.open(); console.write("idformula :" + select1.selectedindex.tostring() + "," + "id rol :" + select2.selectedindex.tostring() + "," + "nombre :" + cargo.text); comand.executescalar(); response.redirect("~/public/cargo/cargos.aspx"); } }

}

and page asp

<asp:content runat="server" contentplaceholderid="contentplaceholder1"> <div class="container"> <div class="row"> <div class="col-md-6"> <div class="form-group"> <label>cargo</label> <asp:textbox runat="server" id="cargo" cssclass="form-control" required="true"></asp:textbox> </div> <div class="form-group"> <label>formula asociada</label> <select id="select1" runat="server" name="d1"> </select> </div> <div class="form-group"> <label>rol asociada</label> <select id="select2" runat="server" name="d2"> </select> </div> <div class="form-group"> <asp:button id="btn_login" onclick="docreatecargo" cssclass="btn btn-primary btn-lg btn-block" text="guardar" runat="server"/> </div> </div> </div> </div>

how can prepare it??

for next lines of code:

comand.parameters.addwithvalue("@idformula", select1.selectedindex.tostring()); comand.parameters.addwithvalue("@idrol", select2.selectedindex.tostring());

[controlid].selectedindex returning index of selected item in binding source , not appropriate id database.

comand.parameters.addwithvalue("@idformula", select1.value.tostring()); comand.parameters.addwithvalue("@idrol", select2.value.tostring());

c# asp.net sql-server sqlexception