I have a textbox value with a Supplyer ID, I want to make a search in a table Suppliers to return the name of that Supplier ID in a textbox? (C#)

[F.oliveirarocha]

Hi folks,

I'm using C# and SQL Server, I have a form "accounts payables", and I need to get the name of supplier, on a textbox, based on the supplier ID textbox. At the formLoad is working well, but I included two buttons "forward" and "back". So, when the supplier ID changes, should change the name as well, in a textbox beside, and its not workign because I should make a "linq" with the IDtextbox.

The database connection is working properly, I'm using DataContextFactory.DataContext and also bindingsource.Datasource.

How to do that using, Lambda, Linq, or SqlCommand with select?

Thanks in advance.

Continue reading...