Loading

textbox access autonunber

jorge Rodrigues

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

vijay kumar18y ago
use like this clientid = '"+ Convert.Toint32(id)+"'
0
Dinesh Tawar20y ago
this.dvclientes.SelectCommand.CommandText="SELECT * FROM clientes where (id_Cliente = " & n & ")";

try this code and let me know
0