order of datagrid columns
-
i have populated a data grid with like this dim QryFrames As String = "SELECT F.ProductId, F.BrandName, F.Collection, F.Temple, F.Bridge, F.Eye, F.FrameName, F.Color, F.Meterial, F.FrameType,F.FrameShape, F.RimType, F.LenseColor, F.Gender,F.QtyInHand,F.ReorderLevel FROM Frames AS F INNER JOIN Stock AS S ON F.ProductId = S.ProductId and F.GrnNo=S.GrnNo" ds = classes_obj.getRecord(QryFrames) dgAddReorder.DataSource = ds.Tables(0) here getRecord function return dataset for passes qry string. this works on index change event of combo box. my problem is user change combo box selected item this return (populate data grid) different order.that mean not in same order. eg. say i want to get ReorderLevel for last column of data grid.so i place it as last item of Qry.but different times it get different location.(but first time ok. i think this because of cashing or something of dataset.) i want to get this same position every time. regards. amila pradeep