How do I get the ComboBox to show always as 1 element the element with the same name as the user

Joao 0

16y2.8k

This is the code:

 string strConn = (@"Data Source=MY-PC;Initial Catalog=RgpNews;Integrated Security=True;Trusted_Connection=True;connection timeout=30;");

SqlConnection conn = new SqlConnection(strConn);

try

{

conn.Open();

string selecttable = String.Format(@"SELECT [IdName], [Name] FROM [RgpNews].[dbo].[Users]");

SqlDataAdapter da = new SqlDataAdapter(selecttable, conn);

SqlCommandBuilder cmdBldr = new SqlCommandBuilder(da);

//da.Fill(dt);

DataTable datat = new DataTable();

da.Fill(datat);

comboPaisesbox.DisplayMemberPath = "Name";

comboPaisesbox.SelectedValuePath = "IdName";

comboPaisesbox.DataContext = datat;

XMAL Code is;

Regards,

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Bob Whelan16y ago
I'm assuming that the user that you want to see in the combobox is the currently logged in user. Once the SQL executes can't you just use the combobox.SelectedValue or combobox.SelectedIndex? I haven't worked too much with WPF but in web or win development that's how I would do it.
0