newbie trying to trigger off this statement in a Main form C#...
command.CommandText = "SELECT CustomerName FROM spCustomersandContacts WHERE CustomerCounter = " + form.Counter + ""; //Works ok and returns value
this.txtCustomerName.DataBindings.Add("Text", mydatabaseDataSet, "spCustomersandContacts.CustomerName"); //nothing happens
then populate txtbox with the result, it does run with no errors and when i put a break point ont the SQL code it does have the value OK but it does not poulate the txtbox, is my syntax wrong on the txtbox line?
note:-Definition of form.counter holds a value [Counter] returned from another form