Sorting in windows application

Hii,

@vulpes : at from load i have assigned ValueType property as u mentioned...but still it's not working...

steps wht i hve done till now
1. Datagridview columns property has different columns such as LoanId,CustomerName....
2. Fetched data in dataset and assiged to columns 
3. at load i set valuetype property of column 0 to int

Code

at btnSearch:
grdCustLoanDetail.Rows[i].Cells[0].Value = dsSearch.Tables[0].Rows[i]["LoanId"].ToString();

at Load
grdCustLoanDetails.Columns[0].ValueType = typeof(int);

still prob is same

thx

Hii sam



it's a windows application....




thx

Note that this question is in the C# Language forum but it is not a question about the C# Language. There are other forums that are more appropriate. For example, the question says "datagrid" so if it was in the ASP .Net forum it would be more clear that the control is a DataGrid. Note that Vulpes said DataGridViewColumn and if this question is actuallly about a DataGridView then it would help if the question was in the Wndows Forms forum.

So what is it? Is the applicaiton a Windows Forms application using a DataGridView or an ASP .Net applicaiton using a DataGrid or is it something else?

Hi Amruta,

Note: Please Don't copy the controls from other app and paste it in current apps.Rather drag and drop it from the toolbox.

Try this -

OleDbConnection con = new OleDbConnection(ConnectionString);
            con.Open();
            str = "select * from student";
            com = new OleDbCommand(str, con);
            oledbda = new OleDbDataAdapter(com);
            ds = new DataSet();
            oledbda.Fill(ds, "student");
            DataView dv = new DataView(ds.Tables["student"]);
            dv.Sort = "sid desc";
            dataGrid1.DataSource = dv;
            con.Close();


Thanks

Hii vulpes,


Loan Id is not a string column,it is number column...


thx

If LoanId is a string column then it will sort like that.

To sort it the way you want, it needs to be an int column.

Alternatively, you could change the format of the strings to "01", "02" etc.