Hi all,
I am binding data to dropdownlist like DisplayMember and valuemember.
Before display list in the Dropdownlist i want to display "ALL" text.
Dim da As New SqlDataAdapter("Select Distinct PHR.MAKER_ID CashierCode,EM.Emp_Name CashierName From pos_sales_hdr PHR(NOLOCK),Employee_Mst EM(NOLOCK) Where PHR.MAKER_ID=EM.Emp_Cd AND PHR.Bill_dt Between '" + dtFromDt.Text + "' AND '" + dtToDt.Text + "'", Cnn)
da.Fill(dt)
cboCashier.Items.Insert(0, "ALL")
// am using the above line but it will not work.
cboCashier.DisplayMember = "CashierName"
cboCashier.ValueMember = "CashierCode"
cboCashier.DataSource = dt
cboCashier.SelectedIndex = 0
Thanks in advance