Database Update Problem

[Anselm Patrick]

Hello I'm developing a page that will submit records into multiple tables. But I'm having issues with the primary key. Here ismy Code:

private void addRef_Click(object sender, System.EventArgs e)
        {
            connection = new SqlConnection("user id=iwireless;data source=10.50.1.10;password=ipnxiwireless;initial catalog=ipNX_Telecoms");
            candCommand = new SqlCommand("insert into candidate(FName,Surname,OName,Address,Sex,DoB,SoOrigin,Nationality,Tel_1,Tel_2,Email)values('fname','sname','oname','address','gender','DoB','soo','nationality','mphone','ophone','email')",connection);
            pryKeyCommand = new SqlCommand("select ID from candidate where FName ='Fname' AND Surname ='sname'",connection);
            refCommand = new SqlCommand("insert into refTable(ID,refName,refAddress,refNo,refEmail)values('ID','rName','rAdd','rNo','rEmail')",connection);
            refCommand = new SqlCommand("insert into refTable(ID,refName,refAddress,refNo,refEmail)values('ID','rName_2','rAdd_2','rNo_2','rEmail_2')",connection);
            candAdap = new SqlDataAdapter(candCommand);
            pryKeyAdap = new SqlDataAdapter(pryKeyCommand);
            refAdap = new SqlDataAdapter(refCommand);
            connection.Open();
            candCommand.ExecuteNonQuery();
            pryKeyCommand.ExecuteNonQuery();
            refCommand.ExecuteNonQuery();
            Response.Write("Ok");
        }

]
here is the error I get:

Syntax error converting the varchar value 'ID' to a column of data type int.

[Frinavale]

Hi Anselm Patrick,
Welcome to TDSN!
Please refrain from posting your question in reply to another question (start a new discussion for your question). Also please post your questions in the Forums->.NET area. Thanks.

As for your question, it appears that on line 6 you are supplying 'ID' (which is a string value) when you should be supplying a numeric value.

-Frinny

[nateraaaa]

You apparently have a data type mismatch on ID. It seems that the error message is saying that you are passing a varchar instead of an int. You will either need to convert the varchar to an int using Convert.ToInt32(ID) or change the datatype for the ID column on your table. Give one of these a try and let us know if this fixes your problem.

Nathan