Well convert it then, I don't see where the problem is. Once you are done with the conversion, use that same variable (converted) to pass it into your query. You have plenty of examples online, one of them:http://www.dotnetperls.com/sqlparameter
when you attempt something, then post your code here if you run into trouble.
so i got
so my issue is that im used to php and mysql..my teachers said that i need to but that a side for now..cause i can get mixed up..
so were im confused
i need to read the line and search table for id_Artiste
(sorry french classes)
struct Oeuvre //table Oeuvre
public string Titre;
public int id_O;
public int Id_Artiste;
public string AnneeAquis;
public double ValeurEstimer;
public double PrixdeVente;
public string etat;
// public string Suivis;
static Oeuvre Oeuvres = new Oeuvre;
static int nbreO = 0;
static void rechercheOeuvres()
string Oeuvres = new string;
Console.WriteLine("enter id ? ");
int nb_element = Convert.ToInt32(Console.ReadLine());
I'm sorry I thought that you have a database involved. Just use a for loop and inside your for loop check if the id matches the user-input, if it does then print out the information or whatever you want to show to user.