a parameter is missing. parameter ordinal = 1 dataAdapter

Question

This is my code:

String client = textbox.text;
try {
    connexion.da = new SqlCeDataAdapter("Select NOM_PRENOM ,NUM_FAC_CLI ,SOLDE_RESTANT ,DATE_FACT ,MODE_PAIEMENT from EXP WHERE NOM_PRENOM_CLI=@client ", connexion.objConn);         
    connexion.da.Fill(ds, "EXPORT");
}

I can't find a property da.Parameters.add("@client", client).

Any suggestions?

Answer 1

you can add parameters like this

da.SelectCommand.CommandType = CommandType.Text; da.SelectCommand.Parameters.Add("@client", client);