i want to display the data in a grid view in a category wise

Question

Hai i want to retrieve the records from a sql table in a category wise and display them it in a grid view. Thank u

Sam Hobbs · Answer

I assume this is for a Windows Forms desktop application; if not then you should have created this thread in the forum relevevant to your application. There are many ways to do this. One way is to bind your DataGridView and a combobox to your data and when a new selection is made in the combobox set the data sources's filter to the new value.

Crish · Answer

hi just select all the data and make category wise ASC order in stored procedure and bind data to gridview.

Krishna Garad · Answer

In what categories can you explain. I mean is there any Category Table and Another data tables. If the data is present in different two tables then simply go for join select query.