Need Help to get Selected Range from DataGrid using C# WebForm

[Motaz]

Hello I am new to all this, i am trying to have a range selecter for A DataGrid on a WebForm, for example the user needs to select a start Row and an end one, Like Date in a single Row in a Columne etc.

i tryed adding two Labels and Data Binding them to the Selected_Item_Index and then take the String out of them and use an SQL Command "Select Columnename From Tablename Where Columne 1 is Between String1 and String2"
then put the Data into A DataSet or Something.

but its very unclean code.

any ideas?

[r035198x]

Hello I am new to all this, i am trying to have a range selecter for A DataGrid on a WebForm, for example the user needs to select a start Row and an end one, Like Date in a single Row in a Columne etc.

i tryed adding two Labels and Data Binding them to the Selected_Item_Index and then take the String out of them and use an SQL Command "Select Columnename From Tablename Where Columne 1 is Between String1 and String2"
then put the Data into A DataSet or Something.

but its very unclean code.

any ideas?

Moved to forum section

[nateraaaa]

Hello I am new to all this, i am trying to have a range selecter for A DataGrid on a WebForm, for example the user needs to select a start Row and an end one, Like Date in a single Row in a Columne etc.

i tryed adding two Labels and Data Binding them to the Selected_Item_Index and then take the String out of them and use an SQL Command "Select Columnename From Tablename Where Columne 1 is Between String1 and String2"
then put the Data into A DataSet or Something.

but its very unclean code.

any ideas?

Have you considered creating a search on your page so that it will only display the criteria that the user searches for (Start Date to End Date)? You would then pass these parameters to a stored procedure that would return a result set. Store your result set in a dataset and assign the dataset as the datasource property of your datagrid.

Nathan