ComboBox Text into SQL Database with ADO.NET

[scwolf]

Hey,

Well I go this problem, I'm using ADO.NET to manage my database on a project now the problem is that I need to get the values from an external Binding source and when I click save they will be saved in the database I'm using at that moment; for example:

I got my database Games:

id 1
game call of duty

and my database Players

id 1
player roy
game -----

In my players form I got a bindingnavigator bar, a textbox for players but I want to get a ComboBox that retrives information from games and save it into players with the same bindingnavigator save button.

Thanks in advance.

[scwolf]

oh wow.. =( I guess no one is able to help me.

[vsa000]

use a data reader
ex:
while (drResult.read())
x = drResult("id").toString()

end
drResult.close()

of course you must use a stored procedure in order to retrieve the info in a particular table