Filling a Dataset

An exception is thrown when filling my data set. I thought I read something in the a while back (can't find it now) that mentioned you had to do something "special" when querying using a primary key.... I may be wrong. Anyway here is my snipplet:<br><br><br>//au_id is a primary key<br>sqlDataAdapter1.SelectCommand.CommandText = "Select * from authors where au_id=" + dpdlist.SelectedItem.Value;<br>dsinfo1.Clear();<br>sqlDataAdapter1.Fill(dsinfo1); // exception is thrown here:Syntax error converting the <br> // varchar value '172-32-1176' to a column of data type int<br> //172-32-1176 is the value selected from the dropdownlist<br><br><br>Any help is appreciated.

it seems like the value you are getting from your textbox is a string and the au_id in the table is of type int. Both of these should be of the same type. Cast or Convert to make them the same.