textbox access autonunber

Question

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

vijay kumar · Answer

use like this clientid = '+ Convert.Toint32(id)+'

Dinesh Tawar · Answer

this.dvclientes.SelectCommand.CommandText=SELECT * FROM clientes where (id_Cliente =  & n & ); try this code and let me know