I have a textbox value with a Supplyer ID, I want to make a search in a table Supply to return the name of that Supplier ID? (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 ID.

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

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

Thanks in advance.

Continue reading...