sql query order by clause

Question

id name 1 NA 2 jay 3 pole how to do that name in alphabetical order and i don't wanna change that constant name in 'NA' without NA how to Order By using

Hanook · Answer

Simple SQL Server query is as follows: SELECT id name FROM TableName ORDER BY CASE WHEN name = 'NA' THEN CAST(1 AS VARCHAR) ELSE name END

Sanjeeb Lenka · Answer

hi just use asc or desc in your select query then bind it to combo box. Note: as NA is the default don't take it from database. after binding the data to combobox just insert the NA in index possition 0.

Safeer Safeer · Answer

can u please explain that CAST(1 AS VARCHAR)

Hanook · Answer

Welcome

Safeer Safeer · Answer

thnx

Safeer Safeer · Answer

public DataTable SalesmanViewAllForComboFill(ComboBox cmbSalesManbool isAll) { DataTable dtblSalesMan = new DataTable(); try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlDataAdapter sdaadapter = new SqlDataAdapter(SalesmanViewAllForComboFill sqlcon); sdaadapter.SelectCommand.CommandType = CommandType.StoredProcedure; sdaadapter.Fill(dtblSalesMan); if (isAll) { DataRow dr = dtblSalesMan.NewRow(); dr[employeeId] = 0; dr[employeeName] = All; dtblSalesMan.Rows.InsertAt(dr 0); } cmbSalesMan.DisplayMember = EmployeeName; cmbSalesMan.ValueMember = EmployeeId; cmbSalesMan.DataSource = dtblSalesMan; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return dtblSalesMan; } /*-----------------SalesManComboFill--------*/ public void SalesManComboFill() { try { DataTable dtbl = TransactionGeneralFillObj.SalesmanViewAllForComboFill(cmbSalesMan false); } catch (Exception ex) { MessageBox.Show(SO15: + ex.Message OpenMiracle MessageBoxButtons.OK MessageBoxIcon.Information); } } can u explain that sql query