Generation

generate functionFri, 07 Jul 2023

mostrar data en combobox desde una tabla de sql server

/// <summary> /// Llenar combobox desde una tabla en sql server /// </summary> /// <param name="combobox">combobox</param> /// <param name="query">query de la tabla</param> /// <param name="displayMember">columna displaymember</param> /// <param name="valueMember">columna valuemember</param> private void llenarCombobox(ComboBox combobox, string query, string displayMember, string valueMember) { using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["cnx"].ConnectionString)) { connection.Open(); SqlCommand command = new SqlCommand(query, connection); SqlDataAdapter adapter = new SqlDataAdapter(command); DataTable data = new DataTable(); adapter.Fill(data); combobox.DataSource = data; combobox.DisplayMember = displayMember; combobox.ValueMember = valueMember;

Questions about programming?Chat with your personal AI assistant