Editing DataSet?

Question

Hello

how can i modify a dataset generated by visual studio from

this._commandCollection[0].CommandText = "SELECT Plaque FROM Vehicule";

to

this._commandCollection[0].CommandText = "SELECT Plaque FROM Vehicule WHERE Actif=1";

but i keep having an OleDbException on form load on  this.vehiculeTableAdapter1.Fill(this.gestionVehiculeDataSet1.Vehicule);

"No value given for one or more required parameters."

some help please!!!

Answer 1

Hi Stephan,

Is Actif a Column of the Table Vehicule? What's the type of the Actif Column?

If you need to change the CommandText, I suggest you do it in the Designer rather than edit the code immediately.

Please open the xsd in the designer and test in after you modify it.

Please let me know the result.

Best Regards,

---

Bob Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi Stephan,

How is it going with the suggestion?

Is the issue solved?

Best Regards,

---

Bob Wu [MSFT]
MSDN Community Support | Feedback to us