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