dear expert
as i know there's something in .NET framework call currency manager used for navigating dataset, how do i use it in ASP.NET if i want to use it as something like cursor pointing on my dataset where by i can move top, move next, move pervious and last.

thank you

I know how to use Currency Managaer in C#, and I am not sure about ASP.NET

DataView dv;
DataSet dataset11;
sqlDataAdapter1.Fill(dataSet11);
Grid.DataSource = dataset11.Tables[0];
dv = new DataView(dataSet11.Tables[0]);
dv.Sort="SupplierID";
CM =(CurrencyManager) BindingContext[Grid.DataSource];
int x = dv.Find(Int32.Parse(textBox2.Text));
if (x>=0)
{
CM.Position=x;
}

Explanation

1) Connect to DB
2) Fill the dataset using data adapter
3) Set the data source for the grid to display data on the grid
4) Create a dataview using the same data source
dv = new DataView(dataSet11.Tables[0]);

5) Set the sort property of the dataview using a column name of the data source. The column name should be the column by which you want to serach the grid for values

dv.Sort="SupplierID";

So now we have the searchable data grid and we can search the date gird and find the position of row using the following line

dv.Find(value) --> This seraches the dataview for the value and returns the record index. If the record not found then it returns -1.

After having searchable data grid, use the currency manager to bind to grid and position at particular record.To position the cursor in the grid for the searched value follow the below steps

1) Get the Binding context of the grid source and store it on the currency manager

CM =(CurrencyManager) BindingContext[Grid.DataSource];

2) Use the find method to get the record index.
3) If it is a valid index then set the property of Currency manager "position" property to scroll in to searched record in the data grid.

CM.Position=x;





It is not how much we do,
but how much love we put in the doing.

-Mother Theresa

thnx man that reall helped me in vb.net
here is the code for others

If txtfind.Text.Trim = "" Then
                Exit Sub
            End If

            Dim objTimeSheets As DataSet
            objTimeSheets = New TimeSheets

            'Attempt to fill the temporary dataset.
            Me.FillDataSet(objTimeSheets)

            Dim x As Integer

            Dim cm As CurrencyManager
            dim dg as datagid
            ''its better to ccreate the datagrid at design time
            dg.DataSource = Nothing

            dg.DataSource = objTimeSheets
            Dim dv As DataView = New DataView(objTimeSheets.Tables("TimeSheet"))

''sort the view here
            dv.Sort = "TimeSheetNo"

''use the currency manager
            cm = CType(Me.BindingContext(dv), CurrencyManager)
            x = 0

            x = dv.Find(txtfind.Text.Trim)
            If (x >= 0) Then
                MsgBox(x)
            Else
                MsgBox("Values Not Found,Try Again!", MsgBoxStyle.Information)

                Exit Sub
            End If