VB.NET ExecuteNonQuery() command
When I'm using this code to insert data into databse, when server tries to insert it will complain me about FK in the table. One of the tables columns are a FK to a table. What should I do. When I take the relation away from server it works perfect.
<script runat="server">
protected sub Page_Load(Src as Object ,E as EventArgs)
if (IsPostBack)
Page.Validate()
If Page.IsValid then
Dim loConn as New SqlConnection(ConfigurationSettings.AppSettings("M M_CONNECTION_STRING_HWB"))
Dim UDIDS As Integer
Dim cmdInsert as New SQLCommand("reg_userdetails",loConn)
cmdInsert.CommandType = CommandType.StoredProcedure
cmdInsert.Parameters.Add(New SqlParameter("@UDID",SqlDbType.int))
cmdInsert.Parameters("@UDID").Direction = ParameterDirection.Output
cmdInsert.Parameters.Add(New SqlParameter("@UID", SqlDbType.int, 4, "UID"))
cmdInsert.Parameters("@UID").Value = Request("UID")
cmdInsert.Parameters.Add(New SqlParameter("@Fornamn", SqlDbType.nvarchar, 50, "Fornamn"))
cmdInsert.Parameters("@Fornamn").Value = Request("Fornamn")
cmdInsert.Parameters.Add(New SqlParameter("@Efternamn", SqlDbType.varchar, 50, "Efternamn"))
cmdInsert.Parameters("@Efternamn").Value = Request("Efternamn")
cmdInsert.Parameters.Add(New SqlParameter("@Gatuandress", SqlDbType.nvarchar, 50, "Gatuandress"))
cmdInsert.Parameters("@Gatuandress").Value = Request("Gatuandress")
cmdInsert.Parameters.Add(New SqlParameter("@Postnummer", SqlDbType.nvarchar, 5, "Postnummer"))
cmdInsert.Parameters("@Postnummer").Value = Request("Postnummer")
loConn.Open()
cmdInsert.ExecuteNonQuery()
loConn.Close()
UDIDS = cmdInsert.Parameters("@UDID").Value
response.redirect("regsuccess.aspx")
else
end if
end if
end sub
</script>
|
