correct the syntax

Hello Prabhat,

can you please try below code and let me know if not working.

string query = "SELECT * FROM lwpos_categories WHERE parent_id = " + ddlCategory.SelectedValue + " ORDER BY name ";

Order by clause used in SQL side after the where condition if you used where clause in query.
and defualt is asc order of you not write asc keyword in query.

Thanks

0

Mageshwaran R6y ago

Hi prabhat,

Try this Code:

string Query= "SELECT *FROM lwpos_categories where parent_id= " + ddlCategory.SelectedValue + " ORDER BY Name ASC";

0

Dhara Patel6y ago

hi, After 'where' write 'Order By' string query ="SELECT * FROM lwpos_categories WHERE parent_id= " + ddlCategory.SelectedValue "+ ORDER BY name ;

0