combo box value will disable

Question

Dear Sir invoice no 1 was paid so if paided invoices will not display in combo box how can i do that please help me

Gnanavel Sekar · Answer

using (SqlConnection con = new SqlConnection(connectionstring)) { using (SqlCommand cmd = new SqlCommand(SELECT InvoiceId FROM Invoice where status!='Paid')) { cmd.CommandType = CommandType.Text; cmd.Connection = con; con.Open(); ddlCustomers.DataSource = cmd.ExecuteReader(); ddlCustomers.DisplayMember = InvoiceId; ddlCustomers.ValueMember = InvoiceId; con.Close(); } }

Nilesh Shah · Answer

@ Gnanavel Sekar The question category is windows forms and we don't have IsPostBack in win forms :)

Nilesh Shah · Answer

:) how r u getting data to display in combobox? this is not windows forms related issue but a basic business rule Just apply the condition that the DB query does not fetch paid invoices

Gnanavel Sekar · Answer

Thanks @Nilesh Shah