Sorting in windows application

Question

Hiii,

I have a datagrid, to which I haved assigned values from database. Now using up/down buttons from column header i am trying to sort grid, but it is not doing sorting properly....

Example: i have column named LoanId. there are id's like 1,2...10,11...20...
now if i click on column Header Loan Id den it gives me result as 1,10,2,20,.....
i want result as 1,2,...10,11,....

can anyone help me?

thx n Regards
Amruta

Vulpes · Answer

I doubt whether you can just set the ValueType property like that if the data to which the column is bound is of string rather than int type. What we need to know is whether it is of string type. If you do the following immediately after the DGV has been bound to the DataSet what do you see? MessageBox.Show(grdCustLoanDetails.Columns[0].ValueType.ToString());

Amruta Kirdat · Answer

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

Amruta Kirdat · Answer

Hii sam it's a windows application.... thx

Sam Hobbs · Answer

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?

Satyapriya Nayak · Answer

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

Vulpes · Answer

The ValueType property of the DataGridViewColumn you want to sort on will determine how the column is sorted by default (see http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewcolumn.valuetype.aspx ). I'd check that this is in fact set to typeof(int) and not typeof(string).

Amruta Kirdat · Answer

Hii vulpes, Loan Id is not a string column,it is number column... thx

Vulpes · Answer

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.