textbox access autonunber

Aug 9 2006 5:46 PM

I want to read a textbox and make the next query to a access database
 
this.dvclientes.SelectCommand.CommandText="SELECT * FROM clientes where (id_Cliente = "+n+"')";

the problem is the id_cliente have a auto number property and to compare i have to use the same field type.

i tried to convert string to int using:

MyInt = int.Parse(MyString);
MyInt = Convert.Int32(MyString);

but it doesn' t work can someone help


Answers (2)